Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

I need help with IMPDP and the parameter 'EXCLUDE'...

713564Jul 23 2009 — edited Jul 23 2009
Hi all... Im new at this forum and Im looking for some help =)

I'm working with DataPump (EXPDP and IMPDP), and I'm importing some tables from HR... I'm able to import those tables without any problem, but I have to exclude the TRIGGER and PROCEDURES. I'm using the parameter EXCLUDE=TRIGGER,PROCEDURE and it shows me an error message , because its unable to find the object call "PROCEDURE"... if I remove the EXCLUDE=PROCEDURE then it shows no error message... can someone help me?

this is the script Im using....

IMPDP system/mypassword directory=DATA_PUMP REMAP_SCHEMA=HR:EXAMEN include=table:\"in('DEPARTAMENTS','EMPLOYEES','JOB_HISTORY','JOBS')\" EXCLUDE=TRIGGER,PROCEDURE DUMPFILE=IMP_HR.DMP LOGFILE=IMP_HR_.LOG
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 20 2009
Added on Jul 23 2009
1 comment
12,146 views