Oracle Utilities Pocket Reference

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. ...