How to create UTF8 database?

From: <dominica_at_secondhat.com>
Date: 18 Nov 2000 01:50:00 GMT
Message-ID: <8v4n7p$4qq$1@secondhat.secondhat.com>

i All,

I am trying to create a database that support UTF8 As far as I understand

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 Fri Nov 17 2000 - 19:50:00 CST