impdp

Network Link May Not Work When Importing Partitioned Tables

by Ed Chen
December 21, 2016August 22, 2018

I found I can't import partitioned table via NETWORK_LINK.[oracle@test ~]$ impdp system/password tables=sh.sales content=data_only table_exists_action=truncate network_link=system_link_orclImport: Release 11.2.0.4.0 - Production on XCopyright (c) 1982, 2011,… Read More »

How to Resolve impdp Error ORA-31693 with ORA-39116

by Ed Chen
December 18, 2016December 11, 2022

ORA-31693 Got ORA-31693 when import data with schema mode. [oracle@test ~]$ impdp system/password schemas=hr,oe,sh content=data_only table_exists_action=truncate network_link=system_link_orcl ... ORA-31693: Table data object "OE"."ORDER_ITEMS" failed to… Read More »

How to Resolve ORA-02266: unique/primary keys in table referenced by enabled foreign keys

by Ed Chen
December 17, 2016May 25, 2023

ORA-02266 ORA-02266 means that you can't truncate the table because reference keys constraint still depend on the data of the table. Truncate a Single Table… Read More »

How to Disable All Referencing Constraints Before Importing Data

by Ed Chen
December 13, 2016December 11, 2022

Disable Constraints Before you can import with table_exists_action=truncate, you have to disable all referencing constraints. Otherwise, you may get the error: ORA-02266: unique/primary keys in… Read More »

How to Duplicate a Schema from One to Another

by Ed Chen
August 7, 2016May 14, 2021

Suppose you are planning to duplicate user01 schema into user02 schema. Tools like TOAD, SQL Developer can be helpful. But you may also like to… Read More »

How to impdp AS SYSDBA without Password

by Ed Chen
May 13, 2016April 11, 2021

impdp AS SYSDBA Like I talked about expdp as sysdba in the previous post, we usually use system who has sufficient privileges to perform data… Read More »

How to expdp AS SYSDBA without Password

by Ed Chen
May 13, 2016June 4, 2023
4 Comments

expdp AS SYSDBA Normally, we use system to migrate data from one to another, who has pretty enough privileges for all kinds of manipulation at… Read More »

2 Unawared Cases May Produce Large Amount of Archived Logs

by Ed Chen
June 29, 2014December 11, 2022

At times, you may notice that the destination of archived logs was growing so fast unreasonably, and it could be worse, it grew too fast… Read More »

What Oracle Command-line Utilities Need Authentication - Oracle

by Ed Chen
January 11, 2013December 11, 2022

Oracle provides many utilities to operate the infrastructure and database. Some of them need authentications to access database, but some don't. The bottom line is… Read More »

A Systematic Approach to Migrate Databases

by Ed Chen
December 21, 2012September 26, 2021

There are several kinds of database migration: Moving a database. It is to move a database to a more powerful server with the same version.… Read More »

JavaScript is not enabled. Please enable it and reload the page.