-- This file must be run out of the directory containing the initialization file.

startup nomount pfile=\\Filer3\HOME\ORANT\DATABASE\initTEST.ora

-- Create database

create database TEST
     controlfile reuse
     logfile '\\Filer3\HOME\ORANT\DATABASE\log1TEST.ora' size 200K reuse,
               '\\Filer3\HOME\ORANT\DATABASE\log2TEST.ora' size 200K reuse
     datafile '\\Filer3\HOME\ORANT\DATABASE\sys1TEST.ora' size 10M reuse autoextend on
           next 10M maxsize 200M
     character set WE8ISO8859P1;

create rollback segment rb_temp;

-- Create additioanal tablespaces ...

-- USER_DATA: Create user sets this as the default tablespace
-- TEMPORARY_DATA: Create user sets this as the temporary tablespace
-- ROLLBACK_DATA: For rollback segments

create tablespace user_data
     datafile '\\Filer3\HOME\ORANT\DATABASE\usr1TEST.ora' size 3M reuse autoextend on
     next 5M maxsize 150M;

create tablespace rollback_data
     datafile '\\Filer3\HOME\ORANT\DATABASE\rbs1TEST.ora' size 5M reuse autoextend on
     next 5M maxsize 150M;

create tablespace temporary_data
     datafile '\\Filer3\HOME\ORANT\DATABASE\tmp1TEST.ora' size 2M reuse autoextend on
     next 5M maxsize 150M;

alter rollback segment rb_temp online;

-- Change the SYSTEM users' password, default tablespace and
-- temporary tablespace.

alter user system temporary tablespace temporary_data;

alter user system default tablespace user_data;

-- Create 16 rollback segments. Allows 16 concurrent users with open
-- transactions updating the database. This should be enough.

create public rollback segment rb1 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb2 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb3 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb4 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb5 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb6 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb7 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb8 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb9 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb10 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb11 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb12 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb13 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb14 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb15 storage(initial 50K next 50K)
     tablespace rollback_data;
create public rollback segment rb16 storage(initial 50K next 50K)
     tablespace rollback_data;