"tweiss" <tedleyw@yahoo.com> wrote in message
news:a5eedefd.0411031205.77975d32@posting.google.c om...
> 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