Home » RDBMS Server » Server Utilities » CSALTER finished unsuccessfully. (merged 3)
icon4.gif  CSALTER finished unsuccessfully. (merged 3) [message #398960] Mon, 20 April 2009 00:45 Go to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Runing the CSALTER script by : SQL> @?/rdbms/admin/csalter.plb;
is the procedure to alter the charecterset of a database.

My question is where do I want to give my source and destination charecterset names??

regards,
Nataraj.
Re: CSAlter command usage [message #398968 is a reply to message #398960] Mon, 20 April 2009 01:11 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you follow the process detailed in the documentation?

Regards
Michel
Re: CSAlter command usage [message #398971 is a reply to message #398968] Mon, 20 April 2009 01:15 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Michel Cadot wrote on Mon, 20 April 2009 11:41
Did you follow the process detailed in the documentation?



Yes Miche,

I can't find out my answer,
Can you give me some reference?
Re: CSAlter command usage [message #398978 is a reply to message #398971] Mon, 20 April 2009 02:04 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
May be this one: Migrating a Character Set Using the CSALTER Script

Regards
Michel
Re: CSAlter command usage [message #398993 is a reply to message #398978] Mon, 20 April 2009 03:42 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

The document says,
Quote:
To change the database character set, perform the following steps:
1. Shut down the database, using either a SHUTDOWN IMMEDIATE or a SHUTDOWN
NORMAL statement.
2. Do a full backup of the database, because the CSALTER script cannot be rolled
back.
3. Start up the database.
4. Run the Database Character Set Scanner utility.
CSSCAN /AS SYSDBA FULL=Y...
5. Run the CSALTER script.
@@CSALTER.PLB
SHUTDOWN IMMEDIATE; -- or SHUTDOWN NORMAL;
STARTUP;


I can't find out my answer here too..

regards,
Nataraj


Re: CSAlter command usage [message #398995 is a reply to message #398993] Mon, 20 April 2009 03:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because you didn't read carefully the document.
character sets are given on csscan call.

Regards
Michel
Re: CSAlter command usage [message #398997 is a reply to message #398995] Mon, 20 April 2009 03:56 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Do the CSAlter takes the parameters of CSScan implicitly?

if so, how to handle in below scenario?

I've executed CSScan two days before.
Found no changes required.
Today can I initiate the CSAlter.

pls find the attached csalter.plb file for your reference.


regards,
Nataraj
  • Attachment: csalter.plb
    (Size: 6.41KB, Downloaded 2209 times)

[Updated on: Mon, 20 April 2009 04:26]

Report message to a moderator

Re: CSAlter command usage [message #399021 is a reply to message #398997] Mon, 20 April 2009 05:20 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
Note that the CSALTER script does not perform any user data conversion. It only changes the character set metadata in the data dictionary.Thus, after the CSALTER operation, Oracle will behave as if the database was created using the new character set.
Re: CSAlter command usage [message #399025 is a reply to message #399021] Mon, 20 April 2009 05:30 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Babu,
I think u didn't understand my question.

My question is where do I need to give my source and destination charecterset names during the execution of CSAlter?

regards,
Nataraj
Re: CSAlter command usage [message #399029 is a reply to message #399025] Mon, 20 April 2009 05:39 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
Note that the CSALTER script does not perform any user data conversion. It only changes the character set metadata in the data dictionary.Thus, after the CSALTER operation, Oracle will behave as if the database was created using the new character set.


Using "csalter.plb" script. Only change metadata in the data dictionary;

>> where do I need to give my source and destination charecterset names during the execution of CSAlter?

This is not like CSSCAN tool; There is no parameter for CSALTER script.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch12scanner.htm#i1013848
Re: CSAlter command usage [message #399037 is a reply to message #399029] Mon, 20 April 2009 06:04 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

gentlebabu wrote on Mon, 20 April 2009 16:09


Using "csalter.plb" script. Only change metadata in the data dictionary;




Babu, your statement is absolutely wrong.

csalter is used to change the charecterset of the whole database.
Re: CSAlter command usage [message #399040 is a reply to message #399037] Mon, 20 April 2009 06:12 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

I think still your not checking document.

http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch12scanner.htm#i1013848

Quote:
Quote:
Note that the CSALTER script does not perform any user data conversion. It only changes the character set metadata in the data dictionary.Thus, after the CSALTER operation, Oracle will behave as if the database was created using the new character set.



Using "csalter.plb" script. Only change metadata in the data dictionary;

>> where do I need to give my source and destination charecterset names during the execution of CSAlter?

This is not like CSSCAN tool; There is no parameter for CSALTER script.
Re: CSAlter command usage [message #399051 is a reply to message #399040] Mon, 20 April 2009 06:26 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Ok I accept Babu,
Quote:
CSAlter only changes the character set of metadata in the data dictionary,

But still "to which charecterset will the CSAlter changes the character set of metadata in the data dictionary?"

regards,
Nataraj
Re: CSAlter command usage [message #399056 is a reply to message #399051] Mon, 20 April 2009 06:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From tables used by csscan.

Regards
Michel
Re: CSAlter command usage [message #399067 is a reply to message #399056] Mon, 20 April 2009 07:23 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Do the CSAlter takes the parameters of CSScan implicitly?
Re: CSAlter command usage [message #399074 is a reply to message #399067] Mon, 20 April 2009 07:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes.

Regards
Michel
icon4.gif  CSALTER finished unsuccessfully. [message #399210 is a reply to message #398960] Tue, 21 April 2009 02:21 Go to previous messageGo to next message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

I'm using an Oracle 10.2.0.4 database with WE8ISO8859P1 charecterset.

I've done a Character Set Scanner v2.1 (CSScan) on this DB as:
SQL> csscan FULL=Y FROMCHAR=WE8ISO8859P1 TOCHAR=UTF8 ARRAY=1024000 LOG=charcheck CAPTURE=Y PROCESS=4;

Verified the charcheck.txt file,
There is no Convertible, Truncated and Lossy Data exceptions in the Application/User Tables.
Only the Data Dictionary has some 3,392 CLOB "Convertible " datas. I hope we don't need to worry about this.
.
Please find the attached "charcheck.txt" file for your reference.

After ensuring a successful scan, I had shut down the database.

Started Up the Database in Restricted Mode: SQL> startup restrict;

Run the CSALTER script as below:

SQL> @@csalter.plb;
0 rows created.
Function created.
Function created.
Procedure created.

This script will update the content of the Oracle Data Dictionary.
Please ensure you have a full backup before initiating this procedure.
Would you like to proceed (Y/N)?y
old 6: if (UPPER('&conf') <> 'Y') then
new 6: if (UPPER('y') <> 'Y') then

Checking data validility...
Exceptional data found in scanner result

PL/SQL procedure successfully completed.

Checking or Converting phrase did not finish successfully

No database (national) character set will be altered

CSALTER finished unsuccessfully.

PL/SQL procedure successfully completed.

0 rows deleted.

Function dropped.
Function dropped.
Procedure dropped.
SQL>


CSALTER finished unsuccessfully.

Please tell me why this failed?


regards,
Nataraj
  • Attachment: charcheck.txt
    (Size: 8.70KB, Downloaded 2257 times)
Re: CSALTER finished unsuccessfully. (merged 3) [message #546858 is a reply to message #398960] Fri, 09 March 2012 05:52 Go to previous messageGo to next message
vikasgupta14
Messages: 3
Registered: March 2012
Location: india
Junior Member
Hi.
I tried to migrate with my database. I did backup, started in restricted mode the database.
when I run csalter.plb script I got:
SQL> @@csalter.plb
0 rows created.
Function created.
Function created.
Procedure created.
This script will update the content of the Oracle Data Dictionary.
Please ensure you have a full backup before initiating this procedure.
Would you like to proceed ?(Y/N)?Y
old 5: if (UPPER('&conf') 'Y') then
new 5: if (UPPER('Y') 'Y') then
Enter value for 1: UTF8
old 8: param1 := '&1';
new 8: param1 := UTF8';
Checking data validility...
TOCHAR is not superset of FROMCHAR
PL/SQL procedure successfully completed.
0 rows deleted.
Alter database character set....
Checking or Converting phrase did not finish successfully
No database (national) character set will be altered
PL/SQL procedure successfully completed.
SQL>

What should I type where I got "Enter value for 1:" ??

I have already done this with ANOTHER DATABASE with same Oracle version(10.1.0.2.0) and now application working fine, but now i am getting this problem.

How to correct my mistake ?? and what should i do to do it successfully
Re: CSALTER finished unsuccessfully. (merged 3) [message #546860 is a reply to message #546858] Fri, 09 March 2012 06:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no mistake only CSALTER can't handle all cases and it knows it and aborts when it finds it is a case it does not know how to do it.

What is your Oracle version?

Regards
Michel
Re: CSALTER finished unsuccessfully. (merged 3) [message #546866 is a reply to message #546860] Fri, 09 March 2012 06:36 Go to previous messageGo to next message
vikasgupta14
Messages: 3
Registered: March 2012
Location: india
Junior Member
thank you for quick reply

my Oracle version is 10.1.0.2.0.
I am following the same steps mentioned at site below
www.oracle-base.com/articles/10g/CharacterSetMigration.php
Re: CSALTER finished unsuccessfully. (merged 3) [message #546868 is a reply to message #546866] Fri, 09 March 2012 06:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
With the same character sets?
Note that the article is about 10.2

By the way, I don't know why you have the question about "&1". It does not exist in 10.2.

Regards
Michel

[Updated on: Fri, 09 March 2012 06:39]

Report message to a moderator

Re: CSALTER finished unsuccessfully. (merged 3) [message #546869 is a reply to message #546868] Fri, 09 March 2012 06:57 Go to previous messageGo to next message
vikasgupta14
Messages: 3
Registered: March 2012
Location: india
Junior Member
Thanks for reply
Yes this document is for 10.2 and i am having oracle 10.1.0.2

Can you please guide me how to migrate charecter set from "WE8MSWIN1252" to "UTF8" for oracle version 10.1.0.2 .
Re: CSALTER finished unsuccessfully. (merged 3) [message #546870 is a reply to message #546869] Fri, 09 March 2012 07:10 Go to previous message
Michel Cadot
Messages: 68618
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Export/create a new database/import.
This is the ONLY way.

Regards
Michel
Previous Topic: Expdp problem
Next Topic: how to use Escape character for loading data via sql loader
Goto Forum:
  


Current Time: Tue Mar 19 05:36:41 CDT 2024