"Timmy Sin" <tswsin_at_yahoo.com> wrote in message
news:auh5c6$gd2$1_at_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
>
Well, do you want to use Java? There are several java scripts (and they can
take a *very* long time to run ... compiling 8000+ classes ... which is why,
IMHO, most people choose to just copy the starter database from the CD and
live with a not-so-clean database). Before Java, manual creation was exactly
like you describe (well, except for the fact that Oracle7 didn't have LMT).
Received on Fri Dec 27 2002 - 09:46:01 CST
