Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Create 9.2.0 database manually
Thanks for your input. I would change the script accordingly. BTW, how about
the other scripts apart from catalog, catproc and pupbld?
Thanks.
Timmy
"Paul Brewer" <paul_at_paul.brewers.org.uk> ¼¶¼g©ó¶l¥ó·s»D
:3e0f32c9$1_1_at_mk-nntp-1.news.uk.worldonline.com...
> "santosh" <santyspam_at_yahoo.com> wrote in message
> news:aui3vj$7f38d$1_at_ID-84096.news.dfncis.de...
> >
> > "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
> >
> >
> >
> >
> It seems so, but I rather think this is a syntax question, rather than
size
> of extents. For undo, in any version, I'd be surprised if the extent sizes
> were other than uniform :-)
>
>
>> undo_retention=10800
> undo_management=AUTO
>
>
>
> > >Received on Mon Dec 30 2002 - 19:32:28 CST