Hi,
I execute an expdp of MYUSER schema from USER1. This is the parfile:
REUSE_DUMPFILES=YES
CONTENT=ALL
SCHEMAS=MYUSER
INCLUDE=SEQUENCE
INCLUDE=TABLE:"IN (SELECT TABLE_NAME
FROM ALL_TABLES
WHERE OWNER = 'MYUSER'
AND TABLE_NAME NOT LIKE 'TEMP%' )"
DIRECTORY=MY_DIRECTORY
This is my IMPDP command:
impdp USER1/pwdUSER1
REMAP_SCHEMA=MYUSER:USER1
directory=MY_DIRECTORY
content=ALL
DUMPFILE=xxxxx.dmp
logfile=xxx.log
In the import log file there is this error during creating trigger:
ORA-31685: Object type TRIGGER:"USER1"."MYTRIGGER" insufficient privileges:
CREATE TRIGGER "USER1"."MYTRIGGER"
BEFORE UPDATE
ON MYUSER.MYTABLE FOR EACH ROW
DECLARE
BEGIN
.....
....
END;
REMAP_SCHEMA doesn't work for triggers?
Any solution?
Thanks