O'Reilly logo

Oracle Utilities Pocket Reference by Sanjay Mishra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

csscan

Use csscan (Character Set Scanner) to determine the impact of migrating an Oracle database to a new character set. csscan scans the data in the database and generates a report that lists any issues involved in changing the character set.

Syntax

csscan [login] [paramval [paramval...]

login ::= username[/password][@net_service_name]]

paramval ::= {parameter=one_value
             |parameter=(value1[,value2...])}

parameter ::= {
 userid=username/password[@net_service_name]
|full={y|n}
|user=table_owner
|table=table1[,table2[,table3...]]
|exclude=table1[,table2[,table3...]]
|tochar=new_char_set
|fromchar=current_char_set
|tonchar=new_national_char_set
|fromnchar=current_national_char_set
|array=[size_in_bytes]
|process=p
|maxblocks=max_blocks
|capture={y|n}
|supress=s
|feedback=n
|boundaries=bound1 [,bound2 [,bound3 ... ]]
|lastrpt={y|n}
|log=report_file
|parfile=parfile_name
|preserve={y|n}
|lcsd={y|n}
|lcsdata={lossy|truncation|convertible|changeless|all}
|help={y|n} }

Parameters

When you perform a character set scan, you must choose between scanning the entire database (full=y), scanning tables owned by a specific user (user=table-owner), or scanning specific tables (table=table_name...).

Tip

Before you actually migrate your database to a new character set, you should perform a full database scan.

Following are the parameter descriptions:

userid=username/password[@net_service_name]

Specifies the username and password of the user performing the scan. Optionally you can specify a net service name. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required