Well ... here is some generic stuff for you to edit. This is from 8.1.x,
but I think it will still (with an edit or two) get you a running database
in 9.2.x
connect / as sysdba
startup nomount
create database "CRCT2"
maxinstances 8
maxlogfiles 32
character set "US7ASCII"
datafile
'/u09/oradata/CRCT2/system_01.dbf' size 200M
logfile
GROUP 1
('/z01/oradata/CRCT2/redo_01a.log'
,'/z02/oradata/CRCT2/redo_01b.log') size 50M
, GROUP 2
('/z01/oradata/CRCT2/redo_02a.log'
,'/z02/oradata/CRCT2/redo_02b.log') size 50M
, GROUP 3
('/z01/oradata/CRCT2/redo_03a.log'
,'/z02/oradata/CRCT2/redo_03b.log') size 50M
, GROUP 4
('/z01/oradata/CRCT2/redo_04a.log'
,'/z02/oradata/CRCT2/redo_04b.log') size 50M
;
--------------------------
connect / as sysdba
REM * add or subtract to the following as desired
@?/rdbms/admin/catalog.sql
@?/rdbms/admin/catproc.sql
@?/rdbms/admin/catexp.sql
@?/rdbms/admin/catblock.sql
@?/rdbms/admin/catparr.sql
@?/rdbms/admin/catrep.sql
@?/rdbms/admin/utlrp.sql
REM * Create additional rollback segment in SYSTEM before creating
tablespace.
REM *
connect / as sysdba
REM * Need a non-system rollback segment for a while.
create rollback segment r0 tablespace system
storage (initial 16k next 16k minextents 2 maxextents 20);
alter rollback segment r0 online;
REM * Create a tablespace for rollback segments.
create tablespace RBS datafile
'/u09/oradata/CRCT2/rbs_01.dbf' size 1000M
default storage (
initial 1M
next 1M
pctincrease 0
minextents 20
maxextents unlimited
);
REM * Create a tablespace for temporary segments.
create tablespace TEMP datafile
'/u09/oradata/CRCT2/temp_01.dbf' size 1000M
default storage (
initial 1M
next 1M
pctincrease 0
minextents 1
maxextents unlimited
)
TEMPORARY;
REM * Create a tablespace for database tools.
create tablespace TOOLS datafile
'/u09/oradata/CRCT2/tools_01.dbf' size 200M
default storage (
initial 16k
next 16k
pctincrease 0
minextents 1
maxextents unlimited
);
REM * Create a tablespace for miscellaneous database user activity.
create tablespace USERS datafile
'/u09/oradata/CRCT2/user_01.dbf' size 100M
default storage (
initial 16k
next 16k
pctincrease 0
minextents 1
maxextents unlimited
);
REM * Create rollback segments.
create rollback segment r01 tablespace rbs storage (
initial 1M
next 1M
minextents 20
maxextents unlimited
optimal 20m
);
create rollback segment r02 tablespace rbs storage (
initial 1M
next 1M
minextents 20
maxextents unlimited
optimal 20m
);
create rollback segment r03 tablespace rbs storage (
initial 1M
next 1M
minextents 20
maxextents unlimited
optimal 20m
);
create rollback segment r04 tablespace rbs storage (
initial 1M
next 1M
minextents 20
maxextents unlimited
optimal 20m
);
alter rollback segment r01 online;
alter rollback segment r02 online;
alter rollback segment r03 online;
alter rollback segment r04 online;
REM * Since we've created and brought online more rollback segments,
REM * we no longer need the rollback segment in the SYSTEM tablespace.
alter rollback segment r0 offline;
drop rollback segment r0;
alter user sys identified by yeehaa;
alter user system identified by yeehaa;
REM
----------------------------------------------------------------------------
----------
REM Run the following from SQLPLUS
REM connect system/yeehaa
REM @/oracle/app/oracle/product/8.1.7/sqlplus/admin/pupbld.sql
REM alter user sys temporary tablespace temp;
REM alter user system default tablespace tools temporary tablespace temp;
REM alter user dbsnmp default tablespace tools temporary tablespace temp;
REM alter user outln default tablespace tools temporary tablespace temp;
REM grant sysoper,sysdba to system;
REM grant sysoper,sysdba to sys;
REM alter user dbsnmp identified by yeehaa;
REM alter user outln identified by yeehaa;
REM
----------------------------------------------------------------------------
----------
> -----Original Message-----
> From: Ruth Gramolini [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 17, 2003 9:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: recreating a create database file
>
>
> Good morning all,
>
> Somehow all of my scripts to create the databases on my 9i
> sandbox have
> disappeared. Does anyone have a script or trick or something
> to recreate
> these files? I could recreate them manually but I am
> somewhat of a time
> crunch.
>
> Thanks in advance,
> Ruth
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Ruth Gramolini
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephen Lee
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
