Looks to me there is some issue of identifying the correct database
instance to update. Do you keep the same password etc. One way to check
is to change the passwords on one database and see what happens. My
guess is that maybe someone is meddling with your tnsnames.ora. You
know you can point to different instance with the same name and mess
around your database.
Anurag Varma wrote:
> SamuelReyna wrote:
> > No, my mistake. Stupid error. I was "exp"-ing from one schema and
> > "imp"-ing into another and I didn't realize that Oracle maintains
> > references to tables in the old schema in the triggers it creates in
> > the new schema.
>
> Oracle does not maintain references to tables in old schema.
> It only does so if you yourself put the schema reference there.
>
> Try creating triggers the following way:
>
> create trigger x_trig1 before insert on schema1.x ....
>
> and then
>
> create trigger x_trig2 before insert on x ....
>
> You'll find that only in the first case the schema reference is
> kept when exp imp in a different schema.. because you specified
> it in the first place.
>
> Anurag
Received on Fri Jun 30 2006 - 11:17:23 CDT
