OraFAQ Forum: Server Administration » Download Oracle 10g Character set scanner for Solaris

Home » RDBMS Server » Server Administration » Download Oracle 10g Character set scanner for Solaris

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Download Oracle 10g Character set scanner for Solaris [message #397166]

Thu, 09 April 2009 05:04

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

http://www.oracle.com/technology/software/tech/globalization/index.html

the above link contains only the oracle 9i Character set scanner but I need the Oracle 10g Character set scanner for Solaris

please assist me.

Report message to a moderator

Re: Download Oracle 10g Character set scanner for Solaris [message #397170 is a reply to message #397166]

Thu, 09 April 2009 05:13

Michel Cadot
Messages: 68665
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

It is inside your 10g distribution.

Regards
Michel

Report message to a moderator

Re: Download Oracle 10g Character set scanner for Solaris [message #397174 is a reply to message #397170]

Thu, 09 April 2009 05:27

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

Can you pls advise me
1. where the script will be in the distribution and
2. how to run those scripts.

Thanks for your reply.

Report message to a moderator

Re: Download Oracle 10g Character set scanner for Solaris [message #397175 is a reply to message #397174]

Thu, 09 April 2009 05:29

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch12scanner.htm

Babu

Report message to a moderator

Re: Download Oracle 10g Character set scanner for Solaris [message #397179 is a reply to message #397175]

Thu, 09 April 2009 05:38

rtnataraj
Messages: 102
Registered: December 2008

Senior Member

I have the complete pdf of that, thanks.

But where will be the CSMIG script in the distribution?
or how to install or configure it?

Report message to a moderator

Re: Download Oracle 10g Character set scanner for Solaris [message #397184 is a reply to message #397179]

Thu, 09 April 2009 05:45

babuknb
Messages: 1736
Registered: December 2005
Location: NJ

Senior Member

>>I have the complete pdf of that, thanks.

Thanks. Have you checked your PDF file??

http://download.oracle.com/docs/cd/B19306_01/server.102/b14225/ch12scanner.htm#i1006046

Quote:

Creates a user named CSMIG

Assigns the necessary privileges to CSMIG

Assigns the default tablespace to CSMIG

Creates the Character Set Scanner system tables under CSMIG

You can modify the default tablespace for CSMIG by editing the csminst.sql script. Modify the following statement in csminst.sql to assign the preferred tablespace to CSMIG as follows:

ALTER USER csmig DEFAULT TABLESPACE tablespace_name;

Ensure that there is sufficient storage space available in the assigned tablespace before scanning the database. The amount of space required depends on the type of scan and the nature of the data in the database.

On UNIX platforms, run csminst.sql using these commands and SQL statement:

% cd $ORACLE_HOME/rdbms/admin
% sqlplus sys/password as sysdba
SQL> START csminst.sql

Babu

Report message to a moderator