i am having our test database on windows which i migrate from IBM-AIX machine oracle database 4 months back, but my manager say he needs the latets data from ibm unix machine.i did the full export and ftp the export file and try to import on windows server but it gives below error while i execute import.please check the errors and give me any idea about that.thanks in advance.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
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