! echo s01 - create db abc, initial rollbacks

connect internal

startup nomount pfile=/oracle/product/8.1.7/dbs/initabc.ora

create database abc
 logfile
  '/v001/abc/redo_1.log' size 10M reuse,
  '/v002/abc/redo_2.log' size 10M reuse,
  '/v001/abc/redo_3.log' size 10M reuse,
  '/v002/abc/redo_4.log' size 10M reuse
 maxlogfiles 20
 maxlogmembers 5
  datafile '/v001/abc/SYSTEM_0.dbf' size 200M
 maxdatafiles 150
 maxloghistory 400
 noarchivelog
 exclusive;

connect internal
create rollback segment r00 tablespace system
 storage(initial 16k next 16k minextents 2);
alter rollback segment r00 online;

! echo s02 - create rollbacks - 6

create tablespace rbs001 datafile
 '/v001/abc/RBS001_0.dbf' size 200M reuse
  default storage (initial 2M next 2M pctincrease 0 maxextents 200);

create tablespace rbs002 datafile
 '/v002/abc/RBS002_0.dbf' size 200M reuse
  default storage (initial 2M next 2M pctincrease 0 maxextents 200);

create tablespace rbs003 datafile
 '/v001/abc/RBS003_0.dbf' size 200M reuse
  default storage (initial 2M next 2M pctincrease 0 maxextents 200);

create tablespace rbs004 datafile
 '/v002/abc/RBS004_0.dbf' size 200M reuse
  default storage (initial 2M next 2M pctincrease 0 maxextents 200);

create tablespace rbs005 datafile
 '/v001/abc/RBS005_0.dbf' size 200M reuse
   default storage (initial 2M next 2M pctincrease 0 maxextents 200);

create tablespace rbs006 datafile
 '/v002/abc/RBS006_0.dbf' size 200M reuse
  default storage (initial 2M next 2M pctincrease 0 maxextents 200);

! echo s03 - create temp, users tools

create tablespace temp datafile
 '/v002/abc/TEMP_0.dbf' size 1000M reuse
  default storage
  (initial     1M
   next        1M
   pctincrease 0
   maxextents  1000);

create tablespace users datafile
 '/v002/abc/USERS_0.dbf' size 200M reuse;

create tablespace tools datafile
 '/v002/abc/TOOLS_0.dbf' size 200M reuse;

! echo s04 - rollback house keeping, sys,system tablespaces

create rollback segment r01 tablespace rbs001 storage (optimal 30M);
create rollback segment r02 tablespace rbs002 storage (optimal 30M);
create rollback segment r03 tablespace rbs003 storage (optimal 30M);
create rollback segment r04 tablespace rbs004 storage (optimal 30M);
create rollback segment r05 tablespace rbs005 storage (optimal 30M);
create rollback segment r06 tablespace rbs006 storage (optimal 30M);

alter rollback segment r01 online;
alter rollback segment r02 online;
alter rollback segment r03 online;
alter rollback segment r04 online;
alter rollback segment r05 online;
alter rollback segment r06 online;

alter rollback segment r00 offline;

alter user sys temporary tablespace temp;
alter user system temporary tablespace temp;
alter user system default tablespace users;

! echo s05 - create objects

@?/rdbms/admin/catalog
@?/rdbms/admin/catproc

connect system/manager

@?/rdbms/admin/catdbsyn
@?/sqlplus/admin/pupbld