csscan report advice [message #312145] |
Tue, 08 April 2008 01:52 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
Current charctaer set: US7ASCII
NEW charcater set: AL32UTF8
I ran cscan utility and found 90 exceptional user tables's varchar2 type columns.
[Distribution of Convertible Data per Column]
USER.TABLE|COLUMN Convertible Exceptional
-------------------------------- ---------------- ----------------
SYS.METASTYLESHEET|STYLESHEET 25 0
SYS.EXTERNAL_TAB$|PARAM_CLOB 1 0
OE.CUSTOMERS|CUST_FIRST_NAME 0 1
OE.CUSTOMERS|CUST_EMAIL 0 1
TRET.OPER|OP_PASSWD 0 34
TRET.OP_MAST|OP_PASSWD 0 52
BATB.SC_CODE|GRANT_NO 0 1
BATB.SC_CODE|H_CODE 0 1
As all these columns are of varchar2 type,How could i remove them from exceptional list.
As in AL32UTF8,a 1 character is of 3 bytes,do ineed to increase the values of the columns and then rerun sscan?
|
|
|
|
Re: csscan report advice [message #312160 is a reply to message #312145] |
Tue, 08 April 2008 02:19 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
There is one more column shown in the docs
"Application Data Individual Exceptions"
This could tell whats the reason behind these exceptions.
How to activate it?
I don't see any option in csscan to use to apply it.
|
|
|
|
|
|
|
Re: csscan report advice [message #312290 is a reply to message #312145] |
Tue, 08 April 2008 07:50 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
The fields are in varchar2 type.
Whne i issued alter database character set command,
It failed
reason CLOB datatype exists.
There are many $ tables that have clob datatype.
What should i do to them?
Truncate them also.
CSSCAN did not report any such thing.
|
|
|
|
Re: csscan report advice [message #312348 is a reply to message #312145] |
Tue, 08 April 2008 11:09 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
CSALTER is i guess new in 10g.
I did not find CSALTER.plb in rdbms/admin directory of 9.0.1.
Quote: | This is what I do (export/truncate/import, not necessarily with Oracle exp/imp tools) maybe not the smartest thing
|
But what would truncate do since clob is a datatype and the table structure remains the same after truncation.
It seems the only option left is to recreate the database and import all the data.
|
|
|
|
Re: csscan report advice [message #312481 is a reply to message #312145] |
Wed, 09 April 2008 00:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
ALL_REPCAT_TEMPLATE_OBJECTS
ALL_REPCAT_TEMPLATE_PARMS
ALL_REPCAT_USER_PARM_VALUES
ALL_REPCAT_USER_PARM_VALUES
ATTRIBUTE_TRANSFORMATIONS$
DBA_IAS_GEN_STMTS
DBA_IAS_GEN_STMTS_EXP
DBA_IAS_POSTGEN_STMTS
DBA_IAS_PREGEN_STMTS
DBA_REPCAT_EXCEPTIONS
DBA_REPCAT_TEMPLATE_OBJECTS
DBA_REPCAT_TEMPLATE_PARMS
DBA_REPCAT_USER_PARM_VALUES
DBA_REPCAT_USER_PARM_VALUES
DEFLOB
EXTERNAL_TAB$
EXU9XTB
JIREFRESHSQL$
METASTYLESHEET
SNAP$
USER_REPCAT_TEMPLATE_OBJECTS
USER_REPCAT_TEMPLATE_PARMS
USER_REPCAT_USER_PARM_VALUES
USER_REPCAT_USER_PARM_VALUES
VIEWCON$
_ALL_INSTANTIATION_DDL
DEF$_LOB
DEF$_TEMP$LOB
REPCAT$_EXCEPTIONS
REPCAT$_INSTANTIATION_DDL
REPCAT$_RUNTIME_PARMS
REPCAT$_TEMPLATE_OBJECTS
REPCAT$_TEMPLATE_PARMS
REPCAT$_USER_PARM_VALUES
WM$LOCKROWS_INFO
ONLINE_MEDIA
ONLINE_MEDIA
ONLINE_MEDIA
ONLINE_MEDIA
PRINT_MEDIA
PRINT_MEDIA
WAREHOUSES
These are the tables that have clob datatype.
I don't know which schema they belong to.
DO they hold any significance in normal database operation?
Can i drop them?
|
|
|
|
|
|
|
|
|
|
Re: csscan report advice [message #312625 is a reply to message #312145] |
Wed, 09 April 2008 08:32 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
varu123
Messages: 754 Registered: October 2007
|
Senior Member |
|
|
So before CSALTER,the only option to migrate database character set was to recreate the database and exp/imp even if the new character set is a super set of old one.
Since Dictionary tables are maintained by oracle,so they ought to contain tables with CLOB datatype.
|
|
|
Re: csscan report advice [message #312627 is a reply to message #312625] |
Wed, 09 April 2008 08:36 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
It is UTF8 specific, I never succeeded to upgrade the character set to UTF8 without using exp/imp (but using internal and not supported stuff).
Regards
Michel
|
|
|