How to Export a PDB without Password
Export PDB If we want to export data from a Pluggable Database (PDB) using expdp as sysdba by OS Authentication, we will get errors like… Read More »How to Export a PDB without Password
impdp
How to Resolve IMP-00038: Could not convert to environment character set's handle
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 »How to Resolve IMP-00038: Could not convert to environment character set's handle
impdp Parameter for All Releases of Oracle Database
Here is the list of impdp available parameters for All Releases of Oracle Database. impdp All Parameters for Oracle Database 21c impdp All Parameters for… Read More »impdp Parameter for All Releases of Oracle Database
expdp Parameter for All Releases of Oracle Database
Here is the list of expdp available parameters for All Releases of Oracle Database. expdp All Parameters for Oracle Database 21c expdp All Parameters for… Read More »expdp Parameter for All Releases of Oracle Database
How to Resolve ORA-01400: cannot insert NULL into
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 ORA-01400: cannot insert NULL into
How to Resolve impdp STATISTICS Stuck
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 impdp STATISTICS Stuck
How to Resolve ORA-01438 in GoldenGate
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-01438 in GoldenGate
How to Resolve ORA-39143: dump file may be an original export dump file
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 Resolve ORA-39143: dump file may be an original export dump file
Network Link May Not Work When Importing Partitioned Tables
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 »Network Link May Not Work When Importing Partitioned Tables
How to Resolve impdp Error ORA-31693 with ORA-39116
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 impdp Error ORA-31693 with ORA-39116