expdp

impdp Parameter for All Releases of Oracle Database

by Ed Chen
August 5, 2020August 7, 2020

Here is the list of impdp available parameters for All Releases of Oracle Database. impdp All Parameters for Oracle Database 20c impdp All Parameters for… Read More »

expdp Parameter for All Releases of Oracle Database

by Ed Chen
August 1, 2020August 7, 2020

Here is the list of expdp available parameters for All Releases of Oracle Database. expdp All Parameters for Oracle Database 20c expdp All Parameters for… Read More »

How to Resolve ORA-39143: dump file may be an original export dump file

by Ed Chen
April 23, 2017August 15, 2018

ORA-39143 Was trying to import the data using impdp, but it threw an error ORA-39143. ORA-39143: dump file "/oradata/recovery_area/full.dmp" may be an original export dump… Read More »

How to Duplicate a Schema from One to Another

by Ed Chen
August 7, 2016March 29, 2018

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 expdp AS SYSDBA

by Ed Chen
May 13, 2016May 7, 2019

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 »