Triggers ont work after an import

[Hakimca]

Hi,

I did import from User1 to User2. All was fine except some triggers. I check and notice that the schema of the tables for those triggers is the schema of user1.
Is there any possibility to change the schema or how to make those triggers work


Thanks

[sreddy]

I don't know the function/purpose of the triggers
Giving grants/permissions of DML activities on USER1 tables to USER2 tables will help the situation. Just an idea.

[hbk_emp]

Run utlrp.sql script that is available in orahome/rdbms/admin directory and that should make you plsql objects into valid status and then go and check status in all_objects table with object name = 'trigger name' if you still have errors that find weather you have db_link connected the user you exported and the new user might not have the db link active in status.