Home » RDBMS Server » Server Utilities » csscaner and csalter (Oracle 11gR2 11.1.2.3 OEL 6.5)
csscaner and csalter [message #650211] Tue, 19 April 2016 11:42 Go to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
My 11gR2 Database is running with default character set. something like Wxxxxxxx. Now we want to
Convert it to UTF8 for multipyte support.
My db size is 5TB. I have read that we can use export/import for conversion but I think it is not possible for us to use this
method due to huge down time.
Can we use csscaner and csalter to convert character set with minimum downtime.
Re: csscaner and csalter [message #650212 is a reply to message #650211] Tue, 19 April 2016 11:50 Go to previous messageGo to next message
BlackSwan
Messages: 25751
Registered: January 2009
Location: SoCal
Senior Member
>Can we use csscaner and csalter to convert character set with minimum downtime.
I give up.
Can you?
Realize that if you try to do as above & a problem occurs, then only recourse is to restore the database from backups.
The only supported method to properly establish DB character set is at database creation time.
Re: csscaner and csalter [message #650213 is a reply to message #650211] Tue, 19 April 2016 11:54 Go to previous messageGo to next message
Michel Cadot
Messages: 65255
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Just use them and you will see their answer, it is harmless.

Re: csscaner and csalter [message #654173 is a reply to message #650213] Thu, 28 July 2016 01:05 Go to previous messageGo to next message
smunir362
Messages: 305
Registered: September 2007
Senior Member
csalter cannot run it did nothing...
My existing DB character set is WE8MSMWIN1252 and convert it to UTF8..
Re: csscaner and csalter [message #654175 is a reply to message #654173] Thu, 28 July 2016 01:28 Go to previous message
Michel Cadot
Messages: 65255
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

So you have no other choice than export/import.
Note that since April you'd have finished the task if you had started it. Smile

Previous Topic: Field in data file exceeds maximum length - SQLLDR
Next Topic: ORA-02374/ORA-01722/ORA-02372 while importing a 11.2.0.4-Dump into 12.1.0.2
Goto Forum:
  


Current Time: Sat Dec 16 00:35:42 CST 2017

Total time taken to generate the page: 0.01957 seconds