impdp

ORA-02304: invalid object identifier literal while import with CREATE TYPE OID

 PROBLEM: While importing schema objects, got below errors. ORA-39083: Object type TYPE:”PADADM10″.”NAME_AND_COUNT_ARRAY” failed to create with error: ORA-02304: invalid objec...

SQLFILE parameter in impdp for generating DDL

It can be used, only with IMPDP. This helps in generating the DDLs from a dumpfile. Suppose I have dump file of table DBACLASS.DEP_TAB . If you need the DDL of the table, then use SQLFILE with IMPDP c...

TABLE_EXISTS_ACTION option in IMPDP

TABLE_EXISTS_ACTION parameter is required while importing table, which is already present in the database. We can put required value, according to our requirement.   TABLE_EXISTS_ACTION Action to...

TRUST_EXISTING_TABLE_PARTITIONS in oracle 12.2 datapump

                TRUST_EXISTING_TABLE_PARTITIONS is a new option for the parameter data_option in the impdp utility of Oracle 12.2. Previously, If we are loading data to an existing partitioned...

Datapump New features in Oracle 12.2

          A lot of enhancements has been done in Oracle 12.2 Release.  In this article We will explain the new features of datapump utility in oracle 12.2 Release. 1.Parfile content  written t...

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-56935: existing datapump jobs are using a different version

    While importing in an oracle 12c database, got below error: ERROR:   impdp dumpfile=teset2.dmp logfile=imp_teset2.lod directory=ODSFINAL remap_schema=TEST:CRMB Import: Release 12.1.0.2.0 - ...

ORA-02304: invalid object identifier literal while doing impdp

While doing import, got below error. CREATE TYPE "TEST_CVGCM02"."TEST_TEST2" OID 'BE4C0AFD318A07CBE0443C4A923B4794' AS OBJECT ( NAME varchar2(40), AGE number(4), ID number(5) ) ORA-39083: Object type ...