Category Archives: DataPump

How to Monitor DataPump

1) Get DataPump job details from database: SQL>select JOB_NAME,OPERATION,JOB_MODE,DEGREE,ATTACHED_SESSIONS , STATE from dba_datapump_jobs JOB_NAME OPERATION JOB_MODE DEGREE ATTACHED_SESSIONS STATE ————————– ———- ———- ———- —————– —————————— SYS_EXPORT_SCHEMA_01 EXPORT SCHEMA 4 1 EXECUTING 2) Also the job name can be found from … Continue reading

Posted in DataPump | Tagged , , , , , , | Leave a comment

ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/TABLE/COMMENT

When importing a schema exported from one 12cR1 AL32UTF8 database to another database  with same AL32UTF8 characterset, this ORA -error was generated : ORA-39346: data loss in character set conversion for object SCHEMA_EXPORT/TABLE/COMMENT The error message clearly shows the problem data is from … Continue reading

Posted in DataPump, ORA- ERRORS | Tagged , , , , , , , , | Leave a comment

PLS-00201: identifier ‘SYS.DBMS_DATAPUMP’ must be declared

SYMPOTMS When trying to run datapump impdp into a PDB, the below errors occurred: UDI-06550: operation generated ORACLE error 6550 ORA-06550: line 1, column 100: PLS-00201: identifier ‘SYS.DBMS_DATAPUMP’ must be declared ORA-06550: line 1, column 100: PL/SQL: Statement ignored ORA-06550: … Continue reading

Posted in DataPump | Tagged , | Leave a comment

ORA-39083: Object type TYPE failed to create with error

SYMPTOMS While importing ORMB schemas from default installation to new schemas for another new ORMB environment. $impdp directory=DUMP_DIR dumpfile=ORMB.dmp REMAP_TABLESPACE=CISTS_01:CISADM_1 SCHEMAS=CISADM,CISUSER,CISOPR,CISREAD REMAP_SCHEMA=CISADM:CISADM_1,CISUSER:CISUSER_1,CISOPR:CISOPR_1,CISREAD:CISREAD_1,CIS_USER:CIS_USER_1,CIS_READ:CIS_READ_1 logfile=imp_cisadm_2_cisadm_1.log   … .. . CREATE TYPE “CISADM”.”TY_RMB_DELETE_BILL_TAB”   OID ’40ACB20E52264074E053530F040AF48D’ AS TABLE OF “CISADM”.”TY_RMB_DELETE_BILL_DTL” ORA-39083: Object type … Continue reading

Posted in DataPump, ORA- ERRORS, ORMB | Tagged , , , , , | Leave a comment

How to Understand and Use ESTIMATE and ESTIMATE_ONLY Parameters in DataPump Export

ESTIMATE Parameter The value for parameter ESTIMATE  is either BLOCKS (default) or STATISTICS. BLOCKS: The estimated space used is calculated by multiplying the number of database blocks used by the target objects with the appropriate block sizes. It is  the least accurate … Continue reading

Posted in DataPump | Leave a comment