Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: New Installation of Oracle -> disgarding default database
at www.oreilly.com look at the oracle admin book for example scripts.
I used it for the following script.
set echo on
spool create_ATY2.log
REM * Start the <sid> instance (ORACLE_SID here must be set to <sid>).
REM *
connect internal
startup nomount pfile=/apps/oracle/product/7.3.4/dbs/initATY2.ora
create database "ATY2"
maxinstances 8
maxlogfiles 32
maxdatafiles 100
character set "US7ASCII"
datafile
'/vol04/oradata/ATY2/system01.dbf' size 100M logfile
'/vol04/oradata/ATY2/redo01.01' size 5m, '/vol04/oradata/ATY2/redo02.01' size 5m, '/vol04/oradata/ATY2/redo03.01' size 5m;@/apps/oracle/product/7.3.4/rdbms/admin/catproc.sql
@/apps/oracle/product/7.3.4/rdbms/admin/catalog.sql
alter database add logfile member
'/vol04/oradata/ATY2/redo01.02' to group 1;
alter database add logfile member
'/vol04/oradata/ATY2/redo02.02' to group 2;
alter database add logfile member
'/vol04/oradata/ATY2/redo03.02' to group 3;
create rollback segment temprbs
tablespace system
storage (initial 25K next 25K minextents 2 maxextents 99);
alter rollback segment temprbs online;
drop tablespace rlbk01;
create tablespace rlbk01
datafile '/vol04/oradata/ATY2/rlbk01.01' size 100M
default storage (initial 1m next 1m);
drop tablespace temp01 ;
create tablespace temp01
datafile '/vol01/oradata/ATY2/temp01.01' size 100M
default storage (initial 2m next 2m);
drop tablespace user01 ;
create tablespace user01
datafile '/vol01/oradata/ATY2/user01.01' size 200M
default storage (initial 100k next 100k);
create rollback segment r01
tablespace rlbk01
storage (initial 100k
next 100k optimal 2100k minextents 20 maxextents 250);
create rollback segment r02
tablespace rlbk01
storage (initial 100k
next 100k optimal 2100k minextents 20 maxextents 250);
create rollback segment r03
tablespace rlbk01
storage (initial 100k
next 100k optimal 2100k minextents 20 maxextents 250); alter rollback segment r01 online;
alter rollback segment temprbs offline;
REM * Alter SYS and SYSTEM users, because Oracle will make SYSTEM REM * the default and temporary tablespace by default. REM *
REM * Now run the Oracle-supplied scripts we need for this DB
REM *
@/apps/oracle/product/7.3.4/rdbms/admin/dbmspool.sql
REM * All done, so close the log file and exit.
REM *
spool off
exit
--