Oracle DBA Helper

March 18, 2009

Unicode characterset in Oracle database.

›
Before starting this post let's have an idea about unicode. Unicode is a Universal encoding scheme which is designed to include far more...

How to know list of constraints and reference constraints in a table

›
Simply list of constranits along with the constraint_type you can achieve querying from dba_constraints/ user_constraints/ all_constraints. ...

How to run csscan in the background as a sysdba

›
With a simple command, csscan system/test full=y tochar=WE8MSWIN1252 ARRAY=1024000 process=4 you can run csscan in order to check all char...

CSSCAN fails with error while loading shared libraries: libclntsh.so.10.1

›
Problem Description While running csscan in order to check all character data in the database and tests for the effects and problems of chan...

CSSCAN fails with CSS-00151: failed to enumerate user tables CSS-00120

›
Problem Description While running csscan it fails with ORA-00942, CSS-00151 and CSS-00120 as below. $ csscan user=prod2 tochar=AL32UTF8 ARRA...
›
Home
View web version

About Me

Constant Star
View my complete profile
Powered by Blogger.