OraFAQ Forum: Server Utilities » character set matching?

Home » RDBMS Server » Server Utilities » character set matching? (AIX, Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

character set matching? [message #504758]

Wed, 27 April 2011 10:56

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?

Report message to a moderator

Re: character set matching? [message #504759 is a reply to message #504758]

Wed, 27 April 2011 11:04

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

should I post answer sooner or later?

Report message to a moderator

Re: character set matching? [message #504760 is a reply to message #504759]

Wed, 27 April 2011 11:06

lg123
Messages: 225
Registered: August 2008

Senior Member

sooner the better

Report message to a moderator

Re: character set matching? [message #504762 is a reply to message #504758]

Wed, 27 April 2011 11:16

Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is fine... if you use the appropriate NLS_LANG.

Regards
Michel

Report message to a moderator

Re: character set matching? [message #504764 is a reply to message #504762]

Wed, 27 April 2011 11:38

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?

Report message to a moderator

Re: character set matching? [message #504767 is a reply to message #504764]

Wed, 27 April 2011 11:44

Michel Cadot
Messages: 68634
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

And what is the relation with export?

Regards
Michel

Report message to a moderator

Re: character set matching? [message #504768 is a reply to message #504764]

Wed, 27 April 2011 11:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator