| Export/Import errors [message #504624] |
Tue, 26 April 2011 18:59  |
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  |
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 |
 |
Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
