Hey! Now I have an issue with import. I am using Windows 2003 Server with Oracle 10g database. I am trying to import dump of schema ERP in one database to schema TEST in another database. I get an error when the triggers are to be created in TEST schema. I know why this error comes but I want to know that how it can be rectified.

Problem is like this:
There is a table say BS_Bal_Sheet in schema ERP. A trigger is also created for some DML on this table and trigger is also in schema ERP. So, trigger is created like this in schema TEST:
create trigger TEST. after update of on ERP. ...........;

It means that some table of ERP is referred by the create trigger statement but trigger has to be created on table of TEST. So, the statement fails with ORA-00942 and IMP-00017