Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> CSALTER.plb to ALter Characterset from US7ASCII to AL32UTF8 ...... FAILING for a 10gR2 Database

CSALTER.plb to ALter Characterset from US7ASCII to AL32UTF8 ...... FAILING for a 10gR2 Database

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Tue, 27 Mar 2007 18:42:25 +0530
Message-ID: <BBD944BCAC3AB4499DFBAFB1D8AF302002C8043C@BLRKECMSG11.ad.infosys.com>

Folks

csalter.plb Run ro Alter the Character Set of an Internal TESTING RAC Database (Size 3.1 TB) from US7ASCII to AL32UTF8 is Failing with the message:-

"Unrecognized convertible date found in scanner result"

Qs. Is presence of "TBAADM.PLAN_TABLE" in the CSSCAN Report Below, the cause of Failure?

NOTE - I have thereafter Dropped TBAADM.PLAN_TABLE & RE-initiated CSSCAN where after I will again RE-Run csalter.plb to ALTER the Character Set. I shall revert back to the List with the results.

Thanks indeed

P.S.

CSSCAN Report:-

USER.TABLE|COLUMN                                       Convertible
Truncation            Lossy


-------------------------------------------------- ----------------
---------------- ----------------
SYS.METASTYLESHEET|STYLESHEET 80 0 0 SYS.RULE$|CONDITION 4 0 0 SYS.SCHEDULER$_EVENT_LOG|ADDITIONAL_INFO 1 0 0 SYS.WRH$_SQLTEXT|SQL_TEXT 1,300 0 0 SYS.WRH$_SQL_PLAN|OTHER_XML 1,089 0 0 SYS.WRI$_ADV_ACTIONS|ATTR5 6,720 0 0 SYS.WRI$_ADV_ACTIONS|ATTR6 6,720 0 0 SYS.WRI$_ADV_OBJECTS|ATTR4 8,085 0 0 SYS.WRI$_ADV_RATIONALE|ATTR5 8,736 0 0 SYS.WRI$_ADV_SQLT_PLANS|OTHER_XML 2 0 0 SYS.WRI$_DBU_FEATURE_METADATA|INST_CHK_LOGIC 11 0 0 SYS.WRI$_DBU_FEATURE_METADATA|USG_DET_LOGIC 79 0 0 SYS.WRI$_DBU_FEATURE_USAGE|FEATURE_INFO 4 0 0 SYS.WRI$_DBU_HWM_METADATA|LOGIC 17 0 0 TBAADM.PLAN_TABLE|OTHER_XML 26 0 0
-------------------------------------------------- ----------------
---------------- ----------------
**************** CAUTION - Disclaimer *****************
This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system. ***INFOSYS******** End of Disclaimer ********INFOSYS***
--

http://www.freelists.org/webpage/oracle-l Received on Tue Mar 27 2007 - 08:12:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US