Home » RDBMS Server » Server Utilities » Export/Import errors (AIX, Oracle 11.2.0.2.0, Linux Oracle 10.2.0.3.0)
Export/Import errors [message #504624] Tue, 26 April 2011 18:59 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I was asked to do export/import of some schemas from 10g(linux) to 11g(AIX) using original expor/import method. I did not consider the character set and started doing export and import. while exporting, I get questionable statistics error in export log file. In the import log, I see the error like CREATE DATABASE LINK "xxxxxxxxxxxxx" CONNECT TO "xxxx" IDENTIFIED BY... What can be done with these errors?
Re: Export/Import errors [message #504625 is a reply to message #504624] Tue, 26 April 2011 19:08 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Export/Import errors [message #504626 is a reply to message #504625] Tue, 26 April 2011 20:27 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
while doing export/import, I do not know what all prerequisites I need to take care of. Is there any proper documentation on how to do the task of exporting from 10g(linux) and importing in to 11g(AIX)?
Re: Export/Import errors [message #504627 is a reply to message #504626] Tue, 26 April 2011 20:32 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://tahiti.oracle.com

It would be helpful if you READ & followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/
Re: Export/Import errors [message #504645 is a reply to message #504624] Wed, 27 April 2011 01:01 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
What can be done with these errors?]

1/ You have to care about character sets.
2/ You should not export the statistics.
3/ You should investigate the error on database link but must likely your new database has no (way to) access to the dblink target database.

Regards
Michel


[EDITED by LF: fixed quote tags]

[Updated on: Wed, 27 April 2011 01:44] by Moderator

Report message to a moderator

Previous Topic: Export Error
Next Topic: character set matching?
Goto Forum:
  


Current Time: Thu Mar 28 11:52:15 CDT 2024