impdp

How to Resolve IMP-00038: Could not convert to environment character set's handle

by Ed Chen
September 2, 2020August 21, 2020

IMP-00038 I thought it was a character set conversion problem when using the original import (imp) to import a dump file, so I tried to… Read More »

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-01400: cannot insert NULL into

by Ed Chen
November 27, 2019January 17, 2020

ORA-01400 ORA-01400 means that there's a column which was found as NOT NULL is not listed in the INSERT statement, you have to provide a… Read More »

How to Resolve impdp STATISTICS Stuck

by Ed Chen
October 8, 2018August 14, 2020

Importing Stuck at STATISTICS When I imported data via a network link, I found it stuck at STATISTICS. ... Import: Release 12.1.0.2.0 - Production on… Read More »

How to Resolve ORA-01438 in GoldenGate

by Ed Chen
June 22, 2018December 21, 2018

ORA-01438 with OGG-00869 in GoldenGate REPLICAT was found as ABENDED in the daily check on GoldenGate. ORA-01438 with OGG-00869 is found in REPLICAT report: 2018-06-21… 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 »

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, 2016August 14, 2020

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, 2016September 28, 2018

ORA-02266 Got ORA-02266 when import data in schema mode. [oracle@test ~]$ impdp system/password schemas=hr,oe,sh content=data_only table_exists_action=truncate network_link=system_link_orcl ... ORA-39120: Table "OE"."PRODUCT_INFORMATION" can't be truncated, data… Read More »