Search code examples
oracleimportoracle11gexportdata-dump

Import specific objects from one schema to another in Oracle

I've done export of my db and then I've performed import of same in another schema. But, due to some reasons, I've missed out around 1000 objects including tables, procedures in my dump and so, in new schema, those 1000 objects are not available.

Is there any way to import specifically those 1000 object instead of doing export and import again.

Assumption: Both export and import schema exists on same database.

Solution

  • You can restart the export with the following parameter 

    INCLUDE=TABLE:"IN ('TABL1', 'TAB2')"   --> LIST OF ALL TABLES REQUIRED
or use 
INCLUDE=TABLE --> Will take all tables
INCLUDE=PROCEDURE
INCLUDE=PACKAGE

FOR INDEX : 
INCLUDE=INDEX 
or
INCLUDE=INDEX:"LIKE 'EMP%'"

    While import what I'd suggest is run with this parameter

    TABLE_EXISTS_ACTION=SKIP

    if tables already existing it would skip it.