How to Resolve OGG-00519 with ORA-00942
Recently, I initialized a set of EXTRACT / PUMP / REPLICAT for one schema, but some days after, the REPLICAT abended with this error: 2017-05-10… Read More »How to Resolve OGG-00519 with ORA-00942
Data Pump
How to Resolve IMP-00401 Error Message
IMP-00401: dump file may be an Data Pump export dump file When I use original import utility to import data from a dump file, I… Read More »How to Resolve IMP-00401 Error Message
How to Resolve ORA-39143 Error Message
ORA-39143: dump file may be an original export dump file Was trying to import the data using impdp, but it threw an error ORA-39143. ORA-39143:… Read More »How to Resolve ORA-39143 Error Message
How Oracle Change Character Set
Assuming that you have exported all the data to dump files for later processes. Database Character Set Check current setting on character sets. SQL> column… Read More »How Oracle Change Character Set
How Import Kill Job
Data Pump Interactive Mode Sometimes, you are unable to stop the import or export job on the spot, and no one knows whether it's hanging… Read More »How Import Kill 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 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 Resolve ORA-02266: unique/primary keys in table referenced by enabled foreign keys
How to Disable All Referencing Constraints Before Importing Data
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 Disable All Referencing Constraints Before Importing Data
How to Duplicate a Schema from One to Another
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 Duplicate a Schema from One to Another