issue with import

[younusdba]

Hi all,

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.


IMP-00058
ORA-12560
IMP-00000

[vnktummala]

pls post the complete error message. and what does google says?

Thanks,

[PAVB]

Please provide items next...

1- Oracle version in both sides
2- Attach export log as well as import log
3- Post import script.

[mahajanakhil198]

ora-12560
It is generaaly related to some connection trouble or tnsnames issue

[mahajanakhil198]

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

[vnktummala]

what is the oracle version? and how you are remapping the schemas?

Thanks,

[mahajanakhil198]

version is 10.2.0.1
I haven't of schema remapping..
I'll google it

[mahajanakhil198]

i jus checked that schma remapping is available with impdp utility. I ll try doing import with it.
Thanks

[gtcol]

I doubt if remapping tablespaces, schemas works. I remember we once had to compile the triggers manually.