Home » RDBMS Server » Server Administration » Download Oracle 10g Character set scanner for Solaris
icon4.gif  Download Oracle 10g Character set scanner for Solaris [message #397166] Thu, 09 April 2009 05:04 Go to next message
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.
Re: Download Oracle 10g Character set scanner for Solaris [message #397170 is a reply to message #397166] Thu, 09 April 2009 05:13 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is inside your 10g distribution.

Regards
Michel
Re: Download Oracle 10g Character set scanner for Solaris [message #397174 is a reply to message #397170] Thu, 09 April 2009 05:27 Go to previous messageGo to next message
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.
Re: Download Oracle 10g Character set scanner for Solaris [message #397175 is a reply to message #397174] Thu, 09 April 2009 05:29 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

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

Babu
Re: Download Oracle 10g Character set scanner for Solaris [message #397179 is a reply to message #397175] Thu, 09 April 2009 05:38 Go to previous messageGo to next message
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?
Re: Download Oracle 10g Character set scanner for Solaris [message #397184 is a reply to message #397179] Thu, 09 April 2009 05:45 Go to previous messageGo to next message
babuknb
Messages: 1734
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
Re: Download Oracle 10g Character set scanner for Solaris [message #397185 is a reply to message #397179] Thu, 09 April 2009 05:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
grep -li csmig $ORACLE_HOME/rdbms/admin/*sql

Regards
Michel
Re: Download Oracle 10g Character set scanner for Solaris [message #397211 is a reply to message #397185] Thu, 09 April 2009 07:49 Go to previous message
rtnataraj
Messages: 102
Registered: December 2008
Senior Member

Thank you all!!
Previous Topic: 10g ORA-01033 Shutdown in process
Next Topic: segment size
Goto Forum:
  


Current Time: Sat Dec 10 03:14:01 CST 2016

Total time taken to generate the page: 0.11126 seconds