Home » RDBMS Server » Server Administration » change Character set for oracle 8i databases (8i database)
change Character set for oracle 8i databases [message #593349] Thu, 15 August 2013 13:31 Go to next message
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
Re: change Character set for oracle 8i databases [message #593350 is a reply to message #593349] Thu, 15 August 2013 13:34 Go to previous messageGo to next message
BlackSwan
Messages: 22495
Registered: January 2009
Senior Member
the correct way to establish the database characterset is only at DB creation time.
Re: change Character set for oracle 8i databases [message #593355 is a reply to message #593349] Thu, 15 August 2013 14:37 Go to previous messageGo to next message
John Watson
Messages: 4379
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?
Re: change Character set for oracle 8i databases [message #593358 is a reply to message #593349] Thu, 15 August 2013 15:03 Go to previous messageGo to next message
Michel Cadot
Messages: 58555
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It depends from which character set to which character set and use csscan tool.

Regards
Michel
Re: change Character set for oracle 8i databases [message #593390 is a reply to message #593355] Fri, 16 August 2013 03:53 Go to previous messageGo to next message
gazzag
Messages: 275
Registered: November 2010
Location: Bristol, UK
Senior Member
Support for 8i?
Re: change Character set for oracle 8i databases [message #593396 is a reply to message #593390] Fri, 16 August 2013 06:12 Go to previous messageGo to next message
John Watson
Messages: 4379
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.
Re: change Character set for oracle 8i databases [message #593433 is a reply to message #593396] Fri, 16 August 2013 10:36 Go to previous messageGo to next message
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
Re: change Character set for oracle 8i databases [message #593435 is a reply to message #593396] Fri, 16 August 2013 10:44 Go to previous messageGo to next message
Lalit Kumar B
Messages: 1816
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

Re: change Character set for oracle 8i databases [message #593436 is a reply to message #593435] Fri, 16 August 2013 10:50 Go to previous messageGo to next message
John Watson
Messages: 4379
Registered: January 2010
Location: Global Village
Senior Member
Unlike you, I am sure Smile
Trust me. I'm a DBA.
Re: change Character set for oracle 8i databases [message #593439 is a reply to message #593436] Fri, 16 August 2013 11:14 Go to previous messageGo to next message
Lalit Kumar B
Messages: 1816
Registered: May 2013
Location: World Wide on the Web
Senior Member
John Watson wrote on Fri, 16 August 2013 21:20

Trust me. I'm a DBA.


Do I have any choice Smile . Of course I trust you and the Oracle Gold partner SkillBuilders
Re: change Character set for oracle 8i databases [message #593441 is a reply to message #593439] Fri, 16 August 2013 11:16 Go to previous message
John Watson
Messages: 4379
Registered: January 2010
Location: Global Village
Senior Member
Good answer, man! In that case, here are the links:

http://www.oracle.com/us/support/lifetime-support/index.html
http://www.oracle.com/us/support/library/lifetime-support-technology-069183.pdf



Previous Topic: ORA-01654: unable to extend index
Next Topic: Unable to create database
Goto Forum:
  


Current Time: Fri Jul 25 02:08:47 CDT 2014

Total time taken to generate the page: 0.10609 seconds