Hi everyone,

I have done a full export of a user/schema called user1. Then, I used 'imp' as follows:

imp user2/<pwd> fromuser=user1 touser=user2

Everything seems fine except that the triggers in the user2 schema refer to objects in the user1 schema. For example, triggers which I expected to fire before insert on a user2 table will only fire before inserts on the original user1 table.

Can anyone explain how to avoid this problem?