Oracle Import / Export help

[Itsjustme82]

Hi,

I am learning Oracle export/import options and I wanted to find a way as stated

I have a destination database that I want to import a dump file to but exclude some schemas.

I exported schemas using

expdp user1/pass full=Y dir=tmp dumpfile=node1.expdp.dmp


on the target node,
I want to import full db excluding sys,system,dbsnmp schemas.

is there an option to use IMPDP in linux?



Any help/guidance is much appreciated.

Regards,
An

[gandolf989]

Try doing the exlude on the export. Then you won't have to wait for schema's to export that you don't want to move.

[CODE]
expdp user1/pass full=Y dir=tmp dumpfile=node1.expdp.dmp EXCLUDE=SCHEMA:"IN ('SYS','SYSTEM', 'DBSNMP', 'OUTLN')"
[\CODE]

[gandolf989]

Try doing the exlude on the export. Then you won't have to wait for schema's to export that you don't want to move.

expdp user1/pass full=Y dir=tmp dumpfile=node1.expdp.dmp EXCLUDE=SCHEMA:"IN ('SYS','SYSTEM', 'DBSNMP', 'OUTLN')"