How do I append data with Oracle's impdp?

oracle impdp
Aaron Digulla picture Aaron Digulla · Nov 18, 2009 · Viewed 10.9k times · Source

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?

Answer

Dave Webb picture Dave Webb · Nov 18, 2009

What impdp does for existing tables is controlled by the TABLE_EXISTS_ACTION parameter.

impdp hr/hr TABLES=employees DIRECTORY=dpump_dir1 DUMPFILE=expfull.dmp TABLE_EXISTS_ACTION=APPEND

However, if you're already using CONTENT=DATA_ONLY which it sounds like you are TABLE_EXISTS_ACTION should be defaulting to APPEND so I'm not sure why you're seeing the behaviour you describe.

Related questions

How to change Oracle default data pump directory to import dumpfile?

I'm using impdp to import a backup. But I want change default directory dumpfile. $ impdp system/password@$ORACLE_SID schemas=USER_SCHEMA dumpfile=mydumpfile.dmp logfile=impdpmydumpfile.log Import: Release 11.2.0.3.0 - Production on Mon Mar 16 09:32:05 2015 Copyright (c) 1982, 2011, Oracle and/or …

Read More
Importing selective data using impdp

I have an entire DB to be imported as a dump into my own. I want to exclude data out of certain tables(mostly because they are huge in size and not useful). I cannot entirely exclude those tables since …

Read More
Oracle import dump file throwing ORA-39088 error

I am trying to import data from a dump file created by Oracle 10g data pump utility. The command that I am issuing is impdp \"username/password@DB as sysdba\" remap_schema=SRC_SCHEMA:TARGET_SCHEMA remap_tablespace=source_tablespace:…

Read More