/*****************************************************************************
*
* Filename         - $Workfile:   db_params.sql  $
*
* Author           - Ian Byass
*
* Project Name     - UltraTrak Core 
*
* Source Code
* Identifier       - Database
*
* Design Spec
* Section          - 
*
* Contents         - SQL*Plus script to define the parameters used to build
*                    the UltraTrak database
*
* Language         - Oracle SQL script      
*
* Classification   - Commercial In Confidence
*
*          (c) Ultra Electronics Limited, 2006
*
*****************************************************************************/

-- ==========================================================================
-- Database Name
-- ==========================================================================
define DB_NAME                           = "trak"

-- ==========================================================================
-- Root paths to redo log files
-- ==========================================================================
define DB_FILE_PATH_ROOT                 = "/shared/tagtrak/database"

-- ==========================================================================
-- Tablespace data file paths
-- ==========================================================================
define DB_SYSTEM_PATH_FILE_1             = "/shared/tagtrak/database/dbfs/file1"
define DB_SYSTEM_PATH_FILE_2             = "/shared/tagtrak/database/dbfs/file2"

define DB_SYSAUX_PATH_FILE_1             = "/shared/tagtrak/database/dbfs/file1"
define DB_SYSAUX_PATH_FILE_2             = "/shared/tagtrak/database/dbfs/file2"

define DB_USER_PATH_FILE_1               = "/shared/tagtrak/database/dbfs/file1"
define DB_USER_PATH_FILE_2               = "/shared/tagtrak/database/dbfs/file2"

define DB_UNDO_PATH_FILE_1               = "/shared/tagtrak/database/dbfs/file1"
define DB_UNDO_PATH_FILE_2               = "/shared/tagtrak/database/dbfs/file2"

define DB_LIVE_TABLES_PATH_FILE_1        = "/shared/tagtrak/database/dbfs/file1"
define DB_LIVE_TABLES_PATH_FILE_2        = "/shared/tagtrak/database/dbfs/file2"

define DB_LIVE_INDEXES_PATH_FILE_1       = "/shared/tagtrak/database/dbfs/file1"
define DB_LIVE_INDEXES_PATH_FILE_2       = "/shared/tagtrak/database/dbfs/file2"

define DB_ARCH_TABLES_PATH_FILE_1        = "/shared/tagtrak/database/dbfs/file1"
define DB_ARCH_TABLES_PATH_FILE_2        = "/shared/tagtrak/database/dbfs/file2"

define DB_ARCH_INDEXES_PATH_FILE_1       = "/shared/tagtrak/database/dbfs/file1"
define DB_ARCH_INDEXES_PATH_FILE_2       = "/shared/tagtrak/database/dbfs/file2"

define DB_TEMP_TABLES_PATH_FILE_1        = "/shared/tagtrak/database/dbfs/file1"
define DB_TEMP_TABLES_PATH_FILE_2        = "/shared/tagtrak/database/dbfs/file2"

define DB_TEMP_INDEXES_PATH_FILE_1       = "/shared/tagtrak/database/dbfs/file1"
define DB_TEMP_INDEXES_PATH_FILE_2       = "/shared/tagtrak/database/dbfs/file2"

define DB_HISTORY_PATH_FILE_1            = "/shared/tagtrak/database/dbfs/file1"
define DB_HISTORY_PATH_FILE_2            = "/shared/tagtrak/database/dbfs/file2"

define DB_APPN_AMEND_IDXS_PATH_FILE_1    = "/shared/tagtrak/database/dbfs/file1"
define DB_APPN_AMEND_IDXS_PATH_FILE_2    = "/shared/tagtrak/database/dbfs/file2"

define DB_APPN_AMEND_TABS_PATH_FILE_1    = "/shared/tagtrak/database/dbfs/file1"
define DB_APPN_AMEND_TABS_PATH_FILE_2    = "/shared/tagtrak/database/dbfs/file2"

define DB_APPN_GEN_IDXS_PATH_FILE_1      = "/shared/tagtrak/database/dbfs/file1"
define DB_APPN_GEN_IDXS_PATH_FILE_2      = "/shared/tagtrak/database/dbfs/file2"

define DB_APPN_GEN_TABS_PATH_FILE_1      = "/shared/tagtrak/database/dbfs/file1"
define DB_APPN_GEN_TABS_PATH_FILE_2      = "/shared/tagtrak/database/dbfs/file2"

define DB_APPN_LOGS_IDXS_PATH_FILE_1     = "/shared/tagtrak/database/dbfs/file1"
define DB_APPN_LOGS_IDXS_PATH_FILE_2     = "/shared/tagtrak/database/dbfs/file2"

define DB_APPN_LOGS_TABS_PATH_FILE_1     = "/shared/tagtrak/database/dbfs/file1"
define DB_APPN_LOGS_TABS_PATH_FILE_2     = "/shared/tagtrak/database/dbfs/file2"

define DB_TEMPORARY_PATH_FILE_1          = "/shared/tagtrak/database/dbfs/file1"
define DB_TEMPORARY_PATH_FILE_2          = "/shared/tagtrak/database/dbfs/file2"
define DB_TEMPORARY_PATH_FILE_3          = "/shared/tagtrak/database/dbfs/file3"

-- ==========================================================================
-- Database Character Set
-- ==========================================================================
define DB_CHARACTER_SET                  = "UTF8"

-- ==========================================================================
-- Redo log file size
-- ==========================================================================
define REDO_LOG_FILE_SIZE                = "50M"

-- ==========================================================================
-- SYSTEM data file sizes. Note - there will be two data files per tablespace
-- so the actual tablespace size is DOUBLE the amount specified below.
-- ==========================================================================
define SYSTEM_FILE_SIZE                  = "250M"   -- Tablespace size 500M
define SYSAUX_FILE_SIZE                  = "500M"   -- Tablespace size 1000M
define TEMP_FILE_SIZE                    = "1000M"  -- Tablespace size 2000M
define USER_FILE_SIZE                    = "50M"    -- Tablespace size 100M
define UNDO_FILE_SIZE                    = "2500M"  -- Tablespace size 5000M

-- ==========================================================================
-- LIVE data file sizes. Note - there will be two data files per tablespace
-- so the actual tablespace size is DOUBLE the amount specified below.
-- ==========================================================================
define LIVE_TABLES_FILE_SIZE             = "2000M"  -- Tablespace size 4000M 
define LIVE_INDEXES_FILE_SIZE            = "4000M"  -- Tablespace size 8000M

-- ==========================================================================
-- ARCH data file sizes. Note - there will be two data files per tablespace
-- so the actual tablespace size is DOUBLE the amount specified below.
-- ==========================================================================
define ARCH_TABLES_FILE_SIZE             = "2500M"  -- Tablespace size 5000M
define ARCH_INDEXES_FILE_SIZE            = "5000M"  -- Tablespace size 10000M

-- ==========================================================================
-- TEMP tablespace sizes. Note - there will be two data files per tablespace
-- so the actual tablespace size is DOUBLE the amount specified below.
-- ==========================================================================
define TEMP_TABLES_FILE_SIZE             = "500M"   -- Tablespace size 1000M    
define TEMP_INDEXES_FILE_SIZE            = "1000M"  -- Tablespace size 2000M

-- ==========================================================================
-- HISTORY tablespace size. Note - there will be two data files per 
-- tablespace so the actual tablespace size is DOUBLE the amount specified 
-- below.
-- ==========================================================================
define HISTORY_FILE_SIZE                 = "1500M"  -- Tablespace size 3000M

-- ==========================================================================
-- FAIMS data file sizes. Note - there will be two data files per tablespace
-- so the actual tablespace size is DOUBLE the amount specified below.
-- ==========================================================================
define APPN_AMENDMENTS_IDXS_FILE_SIZE    = "20M"     -- Tablespace size 40M
define APPN_AMENDMENTS_TABS_FILE_SIZE    = "250M"    -- Tablespace size 500M
define APPN_GENERAL_IDXS_FILE_SIZE       = "20M"     -- Tablespace size 40M
define APPN_GENERAL_TABLES_FILE_SIZE     = "100M"    -- Tablespace size 200M
define APPN_LOGS_IDXS_FILE_SIZE          = "20M"     -- Tablespace size 40M
define APPN_LOGS_TABLES_FILE_SIZE        = "100M"    -- Tablespace size 200M

