How to Migrate Data from 9i to 12c via DB Link
Migrate 9i to 12c As I said in How to Resolve ORA-03134, you cannot directly access an Oracle 9i database from an Oracle 12c or… Read More »How to Migrate Data from 9i to 12c via DB Link
Data Migration
How to Set Export Import Character Set
Garbled Text Garbled data was found after importing a normal dump file. After doing some inspections, I found there’s NLS_LANG environment variable for user oracle… Read More »How to Set Export Import Character Set
How to Resolve ORA-03134: Connections to this server version are no longer supported
Background of ORA-03134 As I mentioned in How to Resolve ORA-28040: No matching authentication protocol. ORA-28040 is not difficult to be solved if you were… Read More »How to Resolve ORA-03134: Connections to this server version are no longer supported
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 Compare Row Counts Between Two Databases
Several years ago I made a stored procedure for comparing table row counts between two databases after migration, which can output a very clear and… Read More »How to Compare Row Counts Between Two Databases
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
How to Interrupt and Kill a Data Pump Job
Sometimes, you are unable to stop the import or export job on the spot, and no one knows whether it’s hanging or not. In such… Read More »How to Interrupt and Kill a Data Pump Job
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
How to Resolve ORA-02266: unique/primary keys in table referenced by enabled foreign keys
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 »How to Resolve ORA-02266: unique/primary keys in table referenced by enabled foreign keys