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
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 in linux oracle version is

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: 65084
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.

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

Current Time: Sat Jul 22 16:02:35 CDT 2017

Total time taken to generate the page: 0.16075 seconds