Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Tablespace Transport

Raghav_DBAFeb 27 2019 — edited Feb 28 2019

expdp system/u_pick_it directory=PUMP_BKP dumpfile=devtab.dmp transport_tablespaces=DEVELOPMENT transport_full_check=y

Processing object type TRANSPORTABLE_EXPORT/INDEX_STATISTICS

Processing object type TRANSPORTABLE_EXPORT/INDEX/STATISTICS/FUNCTIONAL_INDEX/INDEX_STATISTICS

Processing object type TRANSPORTABLE_EXPORT/TABLE_STATISTICS

Processing object type TRANSPORTABLE_EXPORT/STATISTICS/MARKER

ORA-39123: Data Pump transportable tablespace job aborted

ORA-39187: The transportable set is not self-contained, violation list is

ORA-39905: Table GENERAL.GORBLOB in tablespace DEVELOPMENT points to LOB segment GENERAL.GORBLOB_BLOB_STORAGE in tablespace BANLOB.

ORA-39907: Index GENERAL.SYS_IL0000079290C00005$$ in tablespace BANLOB points to table GENERAL.GORBLOB in tablespace DEVELOPMENT.

Job "SYSTEM"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at Wed Feb 27 20:55:40 2019 elapsed 0 00:03:57

After Exclude Table still I am getting same error. I am doing first time table space transport and first time I used exclude parameter in EXPDP.

expdp system/u_pick_it directory=PUMP_BKP dumpfile=devtab.dmp transport_tablespaces=DEVELOPMENT exclude=TABLE:"IN('GENERAL.GORBLOB')" transport_full_check=y