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: 68666
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: Fri Jul 05 05:52:57 CDT 2024