Re: Create 9.2.0 database manually

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

I doubt that you can use UNIFORM allocation for UNDO tablespaces. I checked this in 9.0.1 and it gave me an error. Can somebody clarify that this is still the same in 9.2?

TIA
santosh Received on Fri Dec 27 2002 - 11:54:13 CST