[SOLVED] Import specific objects from one schema to another in Oracle

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.