| sm_ahmeds |
Posted: Sep 27, 2007 03:29:14 AM |
Total Post: 53
Joined: Apr, 2007
|
HI,
I GOT AN ERROR WHILE IMPORTING THE DUMP INTO THE DB.
I DONOT KNOW ANY THING ABOUT THE TRIGGERS.
PLEASE HELP ME IN HOW TO VIEW THE TRIGGER ANDHOW TO EDIT AND UPDATE EXISTING TRIGGER
BELOW IS THE ERROR
IMP-00017: following statement failed with ORACLE error 942:
"CREATE TRIGGER "RASTANURA".DELETE_NON_ID_PA_TEST AFTER"
"DELETE ON RTLIMSP1.TEST FOR EACH ROW "
"begin"
"/***** Change History *****/"
"/* Date Author Details */"
"/* 19-Mar-2007 Aadil Created */"
"/* This Trigger will update the result spec table if there is any specifica"
"tion */"
"/* available for the test component */"
"delete_non_id_pa_test( :old.test_number);"
"end;"
Thanks |
|
|
 Ratnaker |
| Posted: Sep 27, 2007 07:19:29 AM |  |
|
Total Post: 136
Joined: Apr, 2007
|
Please send us all error details.
ratnaker
|
|
|
|
|
| positive |
| Posted: Jun 29, 2008 02:53:59 PM | |
|
Total Post: 361
Joined: Jun, 2008
|
Check for proper schema privileges.
check if dependent objects(table on which the trigger has been created) is imported prior to the trigger.
http://neworacledba.blogspot.com/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
