dbassistant shows the characterset.
set
NLS_LANG=AMERICAN_AMERICA.UTF8
.
<dominica_at_secondhat.com> wrote in message
news:8v4n7p$4qq$1_at_secondhat.secondhat.com...
> i All,
>
> I am trying to create a database that support
> UTF8
>
> As far as I understand
>
> 1) I have to have the environment variable.
>
> NLS_LANG=UTF8
>
> 2) when I am creating a database, script should look like:
>
> connect internal
> startup nomount
pfile=/home/orahome/product/8.1.5/admin/DOMTEST/pfile/initDOMTEST.or
> a
> create database DOMTEST
> CONTROLFILE REUSE
> LOGFILE
> GROUP 1 (
> '/home/oradata/DOMTEST/redo01.log'
> ) SIZE 512K,
> GROUP 2 (
> '/home/oradata/DOMTEST/redo02.log'
> ) SIZE 512K
> DATAFILE
> '/home/oradata/DOMTEST/system01.dbf' size 80M
> MAXLOGFILES 16
> MAXLOGMEMBERS 2
> MAXDATAFILES 50
> MAXINSTANCES 1
> MAXLOGHISTORY 100
> CHARACTER SET UTF8 <-----------------------------
> NOARCHIVELOG;
> create rollback segment temp storage (initial 500K next 500K);
> alter rollback segment temp online;
> @$ORACLE_HOME/rdbms/admin/catalog.sql
> @$ORACLE_HOME/rdbms/admin/catproc.sql
> @$ORACLE_HOME/rdbms/admin/dbmspipe.sql
>
@/home/orahome/product/8.1.5/admin/DOMTEST/create/create_domtest_tspaces.sql
> @/home/orahome/product/8.1.5/admin/DOMTEST/create/create_userroll.sql
> connect system/manager
> @$ORACLE_HOME/sqlplus/admin/pupbld.sql
> spool off
>
>
> Thanks a lot in advance,
>
>
> Please EMAIL me directly to
>
>
> dominica_at_secondhat.com
>
>
> Dominica
>
>
>
Received on Sat Nov 18 2000 - 19:56:08 CST
