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