impdp

How do I append data with Oracle's impdp?

Does impdp always truncate the table before it loads the data even if I don't recreate the meta data? If it does, is there an option to tell it to append the data instead? ...

Is there a good workaround to the Oracle IMPDP REMAP_SCHEMA issue with triggers (ORA-39083, ORA-00942)?

One can use the Oracle data pump import tool (IMPDP.EXE) to import one schema into another using the REMAP_SCHEMA option. However there is an issue in that triggers are not properly remapped. This leads to the trigger not being created at all with an error as follows: ORA-39083: Object type TRIGGER failed to create with error: ORA...

Return code/ exit code for Oracle's DataPump API

I wrapped oracle's IMPDP and EXPDP in a console and could not find a good place for the return codes that these two return. I want to be more specific in pointing out errors than just a 0/1 Pass/Fail. ...

Lot of time spent with following waits 'SQL*Net message from client' and 'wait for unread message on broadcast channel'

My application that wraps around Oracle Data pump's executables IMPDP and EXPDP takes random amounts of time for the same work. On further investigation, I see it waiting for again random amounts of time with the event 'wait for unread message on broadcast channel'. This makes the application take anytime b/w 10 minutes to over an hour f...

Oracle: importing data pump dump without knowledge dump file content.

Old approach for exporting/importing whole schema: exp user/pwdp@server FILE=export.dmp OWNER=user ROWS=Y imp newuser/pwd@server FULL=Y FILE=export.dmp New approach: expdp user/pwdp@server DUMPFILE=export.dp DIRECTORY=exportfolder However had a problem with importing: impdp newuser/pwdp@server DUMPFILE=export.dp DIRECTORY=exp...