Home » RDBMS Server » Server Utilities » Import Error
Import Error [message #153149] Thu, 29 December 2005 09:09 Go to next message
ramesh66
Messages: 8
Registered: September 2005
Location: coimbatore
Junior Member
I exported database in oracle9i in one system and i got Export terminated successfully without warnings.

When i am trying to import same dmp file in another system, after creating database with same user name and password,
i am getting error import terminated successfully with warnings.

I expect Problem is that the export was done with 9.2 software and the import is being done with 9.0 stuff.

pl. let me know the solution.
Ramesh

[Updated on: Thu, 29 December 2005 22:26]

Report message to a moderator

Re: Import Error [message #153150 is a reply to message #153149] Thu, 29 December 2005 09:14 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>i am getting error import terminated successfully with warnings.
Which error are you talking about?
http://download-east.oracle.com/docs/cd/B19306_01/server.102/b14219/impus.htm#sthref50

Post relevant portion of your error log.
Post your OS, oracle versions.
Re: Import Error [message #153151 is a reply to message #153149] Thu, 29 December 2005 09:17 Go to previous messageGo to next message
orausern
Messages: 826
Registered: December 2005
Senior Member
Here, you need to see WHICH errors you got? try to compile all invalid objects -that is needed sometimes..and find whether do you get any invalid objects that are VALID in source database?

If all valid objects (in source db)got successfully created and are valid(in target db) then you can ignore this.

Re: Import Error [message #153160 is a reply to message #153149] Thu, 29 December 2005 10:15 Go to previous messageGo to next message
luchino75
Messages: 3
Registered: December 2005
Location: Milano
Junior Member

in the import parameter set ignore=yes commit=yes
do you see the log import file?
The parameter for write this is log=path/import.log

Re: Import Error [message #153313 is a reply to message #153149] Sat, 31 December 2005 05:02 Go to previous message
ramesh66
Messages: 8
Registered: September 2005
Location: coimbatore
Junior Member
problem solved.
becos of version conflict.
Now imported successfully

thanks for your support
ramesh
Previous Topic: query in exporting only structure of tables
Next Topic: Oracle Database Startup
Goto Forum:
  


Current Time: Tue Jul 02 04:30:35 CDT 2024