-- Author:		Ahbaid Gaffoor
-- File:		CreateDB.sql
-- Date:		$Date$
-- Revision:		$Revision$
-- Use:			Create Database

@@defines

spool CreateDB.log

connect "SYS"/"&&sys_password" as SYSDBA
set echo on
spool CreateDB.log

startup nomount pfile="&&parameter_file";

create database "&&dbname"
maxinstances 8 maxloghistory 1 maxlogfiles 16 maxlogmembers 3 maxdatafiles 1000
datafile '&&system_file' SIZE &&system_file_size reuse autoextend off extent management local
sysaux datafile '&&sysaux_file' size &&sysaux_file_size reuse autoextend off
default temporary tablespace &&temp_tablespace tempfile '&&tmp_file' size &&tmp_file_size reuse autoextend off
undo tablespace "&&undo_tablespace" datafile '&&undo_tablespace' size &&undo_file_size reuse autoextend off
character set &&character_set national character set &&ncharacter_set
logfile group 1 ('&&redo1_file_prefix/&&redo_prefix-g01-m1.log','&&redo2_file_prefix/&&redo_prefix-g01-m2.log') size &&redo_log_size,
        group 2 ('&&redo2_file_prefix/&&redo_prefix-g02-m1.log','&&redo3_file_prefix/&&redo_prefix-g02-m2.log') size &&redo_log_size,
        group 3 ('&&redo3_file_prefix/&&redo_prefix-g03-m1.log','&&redo1_file_prefix/&&redo_prefix-g03-m2.log') size &&redo_log_size
user sys identified by "&&sys_password" user system identified by "&&system_password";

set echo off
spool off

PROMPT
PROMPT Catalog  - CreateDBCatalog.sql
PROMPT Finalise - postDBCreation.sql
PROMPT Options  - &&database_options_file
PROMPT