Home » RDBMS Server » Server Utilities » character set matching? (AIX, Oracle 11g)
character set matching? [message #504758] Wed, 27 April 2011 10:56 Go to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
I am trying to export schemas from 10g to 11g. The NLS_CHARACTERSET for 10g is WE8ISO8859P1 and the NLS_CHARACTERSET for 11g is WE8MSWIN1252. Is it fine or do I need to change the character set, so that I will be able to successfully do the export/import?
Re: character set matching? [message #504759 is a reply to message #504758] Wed, 27 April 2011 11:04 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
Senior Member
should I post answer sooner or later?
Re: character set matching? [message #504760 is a reply to message #504759] Wed, 27 April 2011 11:06 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
sooner the better
Re: character set matching? [message #504762 is a reply to message #504758] Wed, 27 April 2011 11:16 Go to previous messageGo to next message
Michel Cadot
Messages: 60004
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is fine... if you use the appropriate NLS_LANG.

Regards
Michel
Re: character set matching? [message #504764 is a reply to message #504762] Wed, 27 April 2011 11:38 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
when I try to delete a database using dbca, I get this error PRCC-1000 parameter db unique name value is not valid. What could be the resolution?
Re: character set matching? [message #504767 is a reply to message #504764] Wed, 27 April 2011 11:44 Go to previous messageGo to next message
Michel Cadot
Messages: 60004
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
And what is the relation with export?

Regards
Michel
Re: character set matching? [message #504768 is a reply to message #504764] Wed, 27 April 2011 11:45 Go to previous messageGo to next message
BlackSwan
Messages: 23155
Registered: January 2009
Senior Member
>What could be the resolution?
bcm@bcm-laptop:~$ oerr prcc 1000
1000, INVALID_PARAM_VALUE, "Parameter {0} value is not valid"
//  *Cause: This is an internal error. The value for the specified parameter is null or empty string.
// *Action: Contact Oracle Support Services.

Re: character set matching? [message #504772 is a reply to message #504767] Wed, 27 April 2011 11:48 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
no relation with export.
Re: character set matching? [message #504774 is a reply to message #504768] Wed, 27 April 2011 11:51 Go to previous messageGo to next message
lg123
Messages: 225
Registered: August 2008
Senior Member
So I need to raise an SR?
Re: character set matching? [message #504779 is a reply to message #504772] Wed, 27 April 2011 12:03 Go to previous message
Michel Cadot
Messages: 60004
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
lg123 wrote on Wed, 27 April 2011 18:48
no relation with export.

So create a new topic.

This one is locked.

Regards
Michel
Previous Topic: Export/Import errors
Next Topic: IMP-00017: following statement failed with ORACLE error 1950
Goto Forum:
  


Current Time: Sat Dec 20 11:59:07 CST 2014

Total time taken to generate the page: 0.06813 seconds