I need help with IMPDP and the parameter 'EXCLUDE'...
713564Jul 23 2009 — edited Jul 23 2009Hi 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