1. Import using NETWORK_LINK 2. QUERY CLAUSE in EXPDP 3. SQLFILE parameter in impdp 4. TABLE_EXISTS_ACTION option in IMPDP 5. EXCLUDE/INCLUDE option 6. DATA_OPTION=SKIP_CONSTRAINT_ERRORS 7.LOGTIME=ALL...
EXPDP
ORA-39142: incompatible version number 4.1 in dump file
While importing a dump into our 11g database, we got the below error. impdp dumpfile=test1.dmp logfile=imp1.log directory=t Import: Release 11.2.0.4.0 – Production on Mon Jan 23 ...
ORA-31623: a job is not attached to this session via the specified handle
PROBLEM: While taking export or import , you may face below issue. oracle@TEST0$ impdp dumpfile=CX_HIZRI_TRANS_Apr10.dmp logfile=test_1_cx_hizri.log tables=SIEBEL.CX_HIZRI_TRANS di...
ORA-04063: view “SYS.KU$_RADM_FPTM_VIEW” has errors
While taking export dump using expdp , if are getting below error. Error: Processing object type DATABASE_EXPORT/SYS_USER/USER Processing object type DATABASE_EX...
ORA-04063: package body “SYS.DBMS_CUBE_EXP” while expdp
PROBLEM: Received ORA-4063 error while taking expdp, like below. $ expdp system/manager directory=EXPDP dumpfile=exptest.dmp logfile=exp_test.log schemas=TEST Export: Release 11.2.0.4.0 - Producti...
How to take expdp of a table to multiple directories in oracle
Suppose you wish to take a expdp backup of a big table, but you don’t sufficient space in a single mount point to keep the dump. In this case we take expdp dump to multiple directory. DEMO: Crea...
ORA-39071: Value for EXCLUDE is badly formed during expdp
PROBLEM: If you are trying to take export using exclude option from kshell prompt, then you may get an error as ORA-39071: Value for EXCLUDE is badly formed. SOLUTION: The workaround to avoid this : e...