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
impdp
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
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
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
How to expdp AS SYSDBA
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 »How to expdp AS SYSDBA
2 Unawared Cases May Produce Large Amount of Archived Logs
At times, you may notice that the destination of archived logs was growing so fast unreasonably, and it could be worse, it grew too fast… Read More »2 Unawared Cases May Produce Large Amount of Archived Logs