Sunday, April 12, 2009

Exclude Database Objects From Datapump Import

You can exclude any database object from importing using a Datapump Import by using this commands

1-Export the whole Schema from a database
expdp system schemas=hr directory=hr_exp dumpfile=hr_exp.dmp

this dumpfile will contain all database objects like Tables,Indexes,Triggers.....

2-Now you can Exclude the objetcs you want with this command

impdp system schemas=hr directory=hr_exp dumpfile=hr_exp.dmp exclude=PROCEDURE,FUNCTION,TYPE,TRIGGER

so in this command you will Exclude PROCEDURE,FUNCTION,TYPE,TRIGGER from importing

No comments: