Home » RDBMS Server » Server Administration » how to convert from WE8MSWIN1252 to WE8ISO8859P1 (oracle 9i,linux)
how to convert from WE8MSWIN1252 to WE8ISO8859P1 [message #387898] Sat, 21 February 2009 10:55 Go to next message
imraan
Messages: 21
Registered: June 2008
Location: ayangudi
Junior Member
hi i performed tablespace level export in windows xp and i tried to import it on linux ,but oracle sends the error

ORA-29345: can not plug a tablespace into a database using a different character set

In windows xp oracle 9i's character set is WE8MSWIN1252 ,in linux oracle's characterset is WE8ISO8859P1;

the version of oracle in xp is 9.2.0.1.0 in linux oracle version is 9.2.0.4.0

is there any possible way to import it.
Re: how to convert from WE8MSWIN1252 to WE8ISO8859P1 [message #387912 is a reply to message #387898] Sat, 21 February 2009 11:13 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't do it at physical (tablespace) level, you have to do it at object level.

Regards
Michel
Previous Topic: transportable tablespace
Next Topic: Error while Recreating controlfile
Goto Forum:
  


Current Time: Tue Dec 06 08:48:00 CST 2016

Total time taken to generate the page: 0.11014 seconds