EXPDP

Expdp Impdp Tutorial

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...

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...