Create 9.2.0 database manually

From: Timmy Sin <tswsin_at_yahoo.com>
Date: Fri, 27 Dec 2002 17:09:26 +0800
Message-ID: <auh5c6$gd2$1@news.hk.linkage.net>

Hi all,

I want to have a very clean 9.2.0 database (without any unnecessary objects) and choose to create it manually instead of using dbca. I've prepared the following script to create the database. I would like to know if there is any other administration scripts (apart from the three scripts shown) that I have to run for the proper functioning of the database. Any comment on the script is also welcomed.

#####################################

CREATE DATABASE test
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 5
MAXDATAFILES 100
CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF8

LOGFILE GROUP 1 ('/database/oradata/test/dbfile/test_redo_11.rdo',
                 '/database/oradata/test/dbfile/test_redo_12.rdo') SIZE 10M,
                GROUP 2 ('/database/oradata/test/dbfile/test_redo_21.rdo',
                 '/database/oradata/test/dbfile/test_redo_22.rdo') SIZE 10M,
                GROUP 3 ('/database/oradata/test/dbfile/test_redo_31.rdo',
                 '/database/oradata/test/dbfile/test_redo_32.rdo') SIZE 10M
DATAFILE '/database/oradata/test/dbfile/test_system_01.dbf'
     SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
DEFAULT TEMPORARY TABLESPACE temp
     TEMPFILE '/database/oradata/test/dbfile/test_temp_01.dbf'
     SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M
UNDO TABLESPACE undo
     DATAFILE '/database/oradata/test/dbfile/test_undo_01.dbf'
     SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;

CREATE TABLESPACE user DATAFILE
'/database/oradata/test/dbfile/test_user_01.dbf'

     SIZE 200M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5M;
@/app/oracle/product/9.2.0/rdbms/admin/catalog.sql
@/app/oracle/product/9.2.0/rdbms/admin/catproc.sql
connect system/manager
@/app/oracle/product/9.2.0/sqlplus/admin/pupbld.sql
exit;

########################################

Thank you very much for your comment.

Regards,
Timmy Received on Fri Dec 27 2002 - 03:09:26 CST