Skip to Main Content

Oracle Database Discussions

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!

ORA-39083: Object type TRIGGER failed to create with error:

706543Jun 12 2009 — edited Jun 29 2009
i m getting these two error when i import data using impdp.

ORA-39083: Object type TRIGGER failed to create with error:
ORA-00942: table or view does not exist

i have exported (expdp) data from production db, when i importing (impdp) the dump file to the test db i m geting the above two errors.

example:

ORA-39083: Object type TRIGGER failed to create with error:
ORA-00942: table or view does not exist
Failing sql is:
CREATE TRIGGER "NEEDLE"."CC_BCK_TRG" BEFORE INSERT OR UPDATE
ON NIIL.cc_bck_mgmt REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW
DECLARE
w_date DATE;
w_user VARCHAR2(10);
BEGIN
SELECT USER,SYSDATE INTO w_user,w_date FROM DUAL;
IF INSERTING THEN
:NEW.cretuser :=w_user;
:NEW.cretdate :=w_date;
END IF;
IF UPDATING THEN
:NEW.modiuser :=w_user;
:NEW.modidate :=w_date;
END IF;
END;

status of the above trigger in pro db is valid. and source table also exist even though i m getting error when i import

please suggest me...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 10 2009
Added on Jun 12 2009
3 comments
1,564 views