Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Importing Triggers from a Different User
Hi,
I did an export at the user level from a user1. Then I imported all the objects of the user1 into user2. Everything seemed to come over fine with the exception of some triggers - they kept the schema of user1 in the triggering statement. This only happened with about half of them - the other half listed user2 in the triggering statement. I can find no differences between the ones that retain the original schema and those that inherit the new one.
Does anyone have any idea what might be happening here???
Thanks,
Ted
Received on Wed Nov 03 2004 - 14:05:44 CST
![]() |
![]() |