Oracle: using impdp from a full DB expdp

oracle import impdp
domiSchenk picture domiSchenk · Sep 26, 2011 · Viewed 12.6k times · Source

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 directory=dp_dir dumpfile=export.dmp logfile=export.log

Would this work? The problem is, in this dump file there are schemas that are already used and I can't overwrite them (I can but it would be pain for me to recover them)

thanks for help

Answer

DCookie picture DCookie · Sep 26, 2011

It should work as you have shown. You might also want to take a look at the TABLE_EXISTS_ACTION parameter to provide additional warm-fuzziness. With that you can skip tables that exist already.

That said, of course you will have a backup of your database before you start? Or if it's a real pain to recover, perhaps you could create another test database to try this out on?

Related questions

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