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