Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Importing Triggers from a Different User

Importing Triggers from a Different User

From: tweiss <tedleyw_at_yahoo.com>
Date: 3 Nov 2004 12:05:44 -0800
Message-ID: <a5eedefd.0411031205.77975d32@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US