Wednesday, July 23, 2008

Character Set Scanner utility of Oracle

After running the csscan we will get three file,
scan.txt
scan.out
scan.err
Now what we have to check in scan.txt:
A) There can't be any "EXEPTIONAL" data ... if we have then we have not done the check whether the utility is installed ot not.
B)export all the data that is "CONVERTIBLE" and then delete the data. export all the data that is "CONVERTIBLE" and then delete the data. You just need to set the NLS_LANG while taking the dump. If you have indexes on those tables, you will get entries in scan.txt under the "[Indexes to be Rebuilt]" section.
c)If there is any "Lossy" data then those rows contain code points that are not currently stored correctly
D)If you have any entries under Truncation That means that the total amount of space needed to store a string can exceed the defined column size.

scan.out is the output of the csscan command.

And in scan.err we will get the rowid of rows whose data should be resized. Or the column should be increased.

No comments:

search engine

Custom Search