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:
Post a Comment