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:   [crayon-5beda8d0a7b30003232881/] SOLUTION: [crayon-5beda8d0a7b37811172644/] Check the value of DST_UPGRADE_STATE (1) , R...

ORA-02304: invalid object identifier literal while doing impdp

While doing import, got below error. [crayon-5beda8d0a823c195932811/] Login to database, Check whether that OID “BE4C0AFD318A07CBE0443C4A923B4794″ exists or not. [crayon-5beda8d0a824248290...

Skip to toolbar