-- Author:		Ahbaid Gaffoor
-- File:		defines.sql
-- Date:		$Date$
-- Revision:		$Revision$
-- Use:			Database parameter definitions

define oracle_home=/dbh/oracle/10204

define dbname=mydbname
define parameter_file=dbcreate.ora

define database_options_file=database_options_&&dbname..sql

define character_set=utf8
define ncharacter_set=al16utf16


define sys_password=oracle
define system_password=&&sys_password

define file_prefix=/dbh/&&dbname

define data_file_prefix=&&file_prefix/data1
define redo1_file_prefix=&&file_prefix/redo1
define redo2_file_prefix=&&file_prefix/redo2
define redo3_file_prefix=&&file_prefix/redo3
define redo4_file_prefix=&&file_prefix/redo4
define redo_log_size=50M
define redo_prefix=redo-t01

define temp_tablespace=temp_ts
define tmp_file_prefix=&&file_prefix/tmp1
define tmp_file=&&tmp_file_prefix/&&temp_tablespace-01.dbf
define tmp_file_size=50M

define undo_tablespace=undo_ts
define undo_file_prefix=&&file_prefix/undo1
define undo_file=&&undo_file_prefix/&&undo_tablespace-01.dbf
define undo_file_size=250M

define system_file=&&data_file_prefix/system-01.dbf
define system_file_size=300M

define sysaux_file=&&data_file_prefix/sysaux-01.dbf
define sysaux_file_size=150M


set verify on