Re: How to create UTF8 database?

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 20 Nov 2000 16:51:30 GMT
Message-ID: <3a1956bf.1645835275@news.earthlink.net>

create database "DEV2"

    maxinstances 8
    maxlogfiles 32
    maxdatafiles 100
    character set "ALT24UTFFSS"
    datafile

        '/u02/oradata/DEV2/system01.dbf' size 100M     logfile

        '/u02/oradata/DEV2/redoDEV201.log' size 20M,
        '/u03/oradata/DEV2/redoDEV202.log' size 20M,
        '/u04/oradata/DEV2/redoDEV203.log' size 20M;

disconnect

On 18 Nov 2000 01:50:00 GMT, <dominica_at_secondhat.com> wrote:

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

---

In case I forgot to mention:
We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes

---

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Mon Nov 20 2000 - 10:51:30 CST