Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Importing Triggers from a Different User
"tweiss" <tedleyw_at_yahoo.com> wrote in message
news:a5eedefd.0411031205.77975d32_at_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
If you hard-coded user1 in the trigger syntax, this won't change during the import. The same thing for pl/sql packages and views.
Matthias Received on Wed Nov 03 2004 - 14:15:56 CST