Export/Import errors [message #504624] |
Tue, 26 April 2011 18:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #504626 is a reply to message #504625] |
Tue, 26 April 2011 20:27 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
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 #504645 is a reply to message #504624] |
Wed, 27 April 2011 01:01 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 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
|
|
|