Importing selective data using impdp

oracle import impdp
atlantis picture atlantis · Mar 26, 2009 · Viewed 54.1k times · Source

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 I need the table object per se(minus the data) and will have to re create them in my schema if I do so. Also in the absence of those table objects , various other foreign constraints defined on other tables will also fail to be imported and will need to be redefined.So I need to exclude just the data from certain tables.I want data from all other tables though.

Is there a set of parameters for impdp that can help me do so?

Answer

DCookie picture DCookie · Mar 26, 2009

I would make two runs at it: The first I would import metadata only:

impdp ... CONTENT=METADATA_ONLY

The second would include the data only for the tables I was interested in:

impdp ... CONTENT=DATA_ONLY TABLES=table1,table2...

Related questions

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
Oracle: using impdp from a full DB expdp

I’ve got a full Dump of an Database (all schema, system etc...) Now I want to import just one schema of this file, is this even possible? As far I got this command: impdp sysadm/sysadm@sysadm schemas=sysadm …

Read More
Oracle: Import CSV file

I've been searching for a while now but can't seem to find answers so here goes... I've got a CSV file that I want to import into a table in Oracle (9i/10i). Later on I plan to use this …

Read More