OraFAQ Forum: Server Administration » change Character set for oracle 8i databases

Home » RDBMS Server » Server Administration » change Character set for oracle 8i databases (8i database)

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

change Character set for oracle 8i databases [message #593349]

Thu, 15 August 2013 13:31

dba707
Messages: 6
Registered: December 2012

Junior Member

How to change Character set for oracle 8i database. Is there anyway to change the Character set without affecting the current database.

Thanks,
Ibrahim

Report message to a moderator

Re: change Character set for oracle 8i databases [message #593350 is a reply to message #593349]

Thu, 15 August 2013 13:34

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

the correct way to establish the database characterset is only at DB creation time.

Report message to a moderator

Re: change Character set for oracle 8i databases [message #593355 is a reply to message #593349]

Thu, 15 August 2013 14:37

John Watson
Messages: 9000
Registered: January 2010
Location: Global Village

Senior Member

If I remember correctly, I used to do it by updating the character set in sys.props$ and then re-creating the controlfile. You risk destroying the database, you know. Better ask Oracle support - you do have a sustaining support contract?

Report message to a moderator

Re: change Character set for oracle 8i databases [message #593358 is a reply to message #593349]

Thu, 15 August 2013 15:03

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It depends from which character set to which character set and use csscan tool.

Regards
Michel

Report message to a moderator

Re: change Character set for oracle 8i databases [message #593390 is a reply to message #593355]

Fri, 16 August 2013 03:53

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Support for 8i?

Report message to a moderator

Re: change Character set for oracle 8i databases [message #593396 is a reply to message #593390]

Fri, 16 August 2013 06:12

John Watson
Messages: 9000
Registered: January 2010
Location: Global Village

Senior Member

gazzag wrote on Fri, 16 August 2013 09:53

Support for 8i?

Sure, 8.1.7 is eligible for sustaining support indefinitely. Or so Oracle says at the moment.

Report message to a moderator

Re: change Character set for oracle 8i databases [message #593433 is a reply to message #593396]

Fri, 16 August 2013 10:36

dba707
Messages: 6
Registered: December 2012

Junior Member

Thanks Black , John , Michel and gazzag.
I will consider all information that you guys mentioned.

Michel I will try csscan tool to check the database is ready to convert or not. Thanks for your all help.
Regrads
Ibrahim

Report message to a moderator

Re: change Character set for oracle 8i databases [message #593435 is a reply to message #593396]

Fri, 16 August 2013 10:44

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

John Watson wrote on Fri, 16 August 2013 16:42

gazzag wrote on Fri, 16 August 2013 09:53
Support for 8i?
Sure, 8.1.7 is eligible for sustaining support indefinitely. Or so Oracle says at the moment.

John -
And I was in a notion that support status says NO MORE. And Orafaq says 8i support status

Not sure about Oracle Lifetime Support Policies.

[Updated on: Fri, 16 August 2013 10:45]

Report message to a moderator