17,377
社区成员
发帖
与我相关
我的任务
分享
system/********@orcl schemas=NEW_PO REMAP_SCHEMA=OLD_PO:NEW_PO REMAP_TABLESPACE=OLD_PO:NEW_PO directory=EXPORT dumpfile=NEW_PO150812.dmp logfile=NEW_PO_812.log
ORA-39083: Object type TRIGGER failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
CREATE TRIGGER "NEW_PO"."MESSAGES_TRG"
BEFORE INSERT
ON OLD_PO.MESSAGES
REFERENCING NEW AS New OLD AS Old
FOR EACH ROW
BEGIN
-- For Toad: Highlight column MSG_ID
:new.MSG_ID := MESSAGES_SEQ.nextval;
END MESSAGES_TRG;