Re-Create ACQ1 Database

Assumed that the Database ACQ1 is corrupted, you are unable recover the damaged database but to re-create the database.

1. Prepare the 'initACQ1.ora' and ensure this file is created or located at /export/home/oracle/oracle9.2.0/dbs/

'initACQ1.ora' :-

*.audit_trail='TRUE'
*.audit_sys_operations='TRUE'
*.audit_file_dest='/export/home/oracle/oracle9.2.0/rdbms/audit/ACQ1'
*.background_dump_dest='/export/home/oracle/admin/ACQ1/bdump'
*.compatible='9.2.0.5.0'
*.control_files='/disk1/oradata/ACQ1/control01.ctl','/disk2/oradata/ACQ1/control02.ctl','/disk3/oradata/ACQ1/control03.ctl'
*.core_dump_dest='/export/home/oracle/admin/ACQ1/cdump'
*.db_block_size=4096
*.db_cache_size=335544320
*.db_file_multiblock_read_count=64# LARGE
*.db_files=1000
*.db_name='ACQ1'
*.dml_locks=500# LARGE
*.global_names=TRUE
*.job_queue_processes=36
*.log_archive_dest='/disk5/ARCHIVELOG'
*.log_archive_format='arch%s.arc'
*.log_archive_start=TRUE
*.log_buffer=327680# LARGE
*.log_checkpoint_interval=10000
*.max_dump_file_size='10240'# limit trace file size to 5 Meg each
*.open_cursors=200
*.processes=300# LARGE
*.sessions=500
*.sga_max_size=2147483648
*.shared_pool_size=512000000# LARGE
*.transactions=550
*.undo_management='auto'
#*.undo_tablespace='UNDO_TBS01','UNDO_TBS02'
*.undo_tablespace='UNDO_TBS01'
*.user_dump_dest='/export/home/oracle/admin/ACQ1/udump'
#remote_login_passwordfile=SHARE

2. Ensure the DB is already shutdown, then delete those old DB *.dbf, *.rdo,*.ctl files by execute this script 'Remove_Existing_DB_Files.sh' which is located at /ata2/CREATE_DB/


IMPORTANT : 

• DO NOT SIMPLY EXECUTE this script as it will corrupt and damage the Database.
• Execute this job ONLY when you wanted to re-created DB.
• You should run this job BEFORE execute 'Create_ACQ1_DB.sh'

The script 'Remove_Existing_DB_Files.sh':-

# Author : Natalie
# Date : 16 Jun 2009
# Purpose : To remove those existing DB *.dbf *.rdo *.ctl
# from the following directories.
# IMPORTANT : DO NOT SIMPLY EXECUTE this script as it will corrupt
# and damage the Database.
# Execute this job ONLY when you wanted to re-created DB.
# You should run this job BEFORE execute 'Create_ACQ1_DB.sh'

## Before
echo "\n\nGenerating Before Remove Files Listing" >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
ls -lrt /*/oradata/ACQ1/*.dbf >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
ls -lrt /*/oradata/ACQ1/*.rdo >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
ls -lrt /*/oradata/ACQ1/*.ctl >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
ls -lrt /export/home/oracle/oracle9.2.0/rdbms/audit/ACQ1 >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
ls -lrt /export/home/oracle/admin/ACQ1/bdump >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
ls -lrt /export/home/oracle/admin/ACQ1/udump >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
ls -lrt /export/home/oracle/admin/ACQ1/cdump >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst

echo "**** End of Generating Before Remove Files Listing ****"


## Removing Files
echo "\n\nRemoving Files" >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
rm /*/oradata/ACQ1/*.dbf >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
rm /*/oradata/ACQ1/*.rdo >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
rm /*/oradata/ACQ1/*.ctl >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
rm /export/home/oracle/oracle9.2.0/rdbms/audit/ACQ1/*.aud >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
rm /export/home/oracle/admin/ACQ1/bdump/* >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
rm /export/home/oracle/admin/ACQ1/udump/* >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
rm /export/home/oracle/admin/ACQ1/cdump/* >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst

echo " ***** End of Removing Files *****"


## After
echo "\n\nGenerating After Files Removed Listing"
ls -lrt /*/oradata/ACQ1 >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
ls -lrt /export/home/oracle/oracle9.2.0/rdbms/audit/ACQ1 >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
ls -lrt /export/home/oracle/admin/ACQ1/bdump >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
ls -lrt /export/home/oracle/admin/ACQ1/udump >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst
ls -lrt /export/home/oracle/admin/ACQ1/cdump >>/ata2/CREATE_DB/LOGS/Remove_DB_Files.lst

echo "**** End of Generating After Files Removed Listing ****"

3. Check the this /ata2/CREATE_DB/LOGS/Remove_DB_Files.lst to ensure those old DB files is being deleted.

4. Now proceed to re-create the ACQ1 DB by executing 'Create_ACQ1_DB.sh' which is located at /ata2/CREATE_DB/

'Create_ACQ1_DB.sh':-

##
## Author           : Natalie
## Date Create      : 02/06/2009
## Sscript Name     : Create_ACQ1_DB.sh
## Purpose          : Script to create database
## Requirement      : The following scripts is required,check and ensure the
##                    scripts is in order to complete the database creation.
##               1.) $ORACLE_HOME/rdbms/admin/standard.sql
##               2.) $ORACLE_HOME/rdbms/admin/catalog.sql
##               3.) $ORACLE_HOME/rdbms/admin/catproc.sql
##               4.) $ORACLE_HOME/sqlplus/admin/pupbld.sql
##
## Important Note   :  Below DDL/ script is generated weekly from the production
##                     DB via "cronjob_extract_ALL.sh by (dbcron id)".
##                     Please check below script before you execute.
##                     If you found the create statement with a '"', please
##                     clear the '"' from the script.
##                     The script's doesn't produce an executable file if the
##                     create statement lack a ';' or a '/'.
##                     My script may be incomplete, it was complete for the
##                     user from which the above was adapted.
##               5.) /ata2/CREATE_DB/01_create_ACQ1_profile.sql
##               6.) /ata2/CREATE_DB/02_create_ACQ1_tablespaces.sql - Please
##                   clear the '"' from the script
##               7.) /ata2/CREATE_DB/03_create_ACQ1_users.sql
##               8.) /ata2/CREATE_DB/04_grant_ACQ1_user_role_orivileges.sql
##               9.) /ata2/CREATE_DB/05_create_DATABASE_LINK.sql
##              10.) /ata2/CREATE_DB/06_rename_GLOBAL_NAME.sql
##              11.) /ata2/CREATE_DB/07_create_SPFILE.sql
##              12.) Can proceed to import backup data into ACQ1
##              13.) Rebuild_ACQ1_schema_ddl.sql - This ddl containe ACQ1 schema.
##

export ORACLE_SID=ACQ1
sqlplus /nolog <
connect / as sysdba;
spool /ata2/CREATE_DB/LOGS/creACQ1.log
startup nomount
create database ACQ1
    maxlogfiles 5
    maxlogmembers 5
    maxdatafiles 1000
    maxloghistory 100
    character set US7ASCII
    NATIONAL CHARACTER SET AL16UTF16
    LOGFILE GROUP 1 ('/disk1/oradata/ACQ1/logACQ11a.rdo', '/disk1/oradata/ACQ1/logACQ11b.rdo') size 50M,
            GROUP 2 ('/disk2/oradata/ACQ1/logACQ12a.rdo', '/disk2/oradata/ACQ1/logACQ12b.rdo') size 50M,
            GROUP 3 ('/disk3/oradata/ACQ1/logACQ13a.rdo', '/disk3/oradata/ACQ1/logACQ13b.rdo') size 50M
    DATAFILE '/disk16/oradata/ACQ1/systemACQ101.dbf' SIZE 500M REUSE
    EXTENT MANAGEMENT LOCAL
    DEFAULT TEMPORARY TABLESPACE TEMP01
         TEMPFILE '/disk21/oradata/ACQ1/temp01_01.dbf'
         SIZE 3500M REUSE
    UNDO TABLESPACE UNDO_TBS01
         DATAFILE '/disk8/oradata/ACQ1/UNDO_TBS01_01.dbf'
         SIZE 2000M REUSE AUTOEXTEND ON NEXT 5120K MAXSIZE UNLIMITED;
connect SYS/CHANGE_ON_INSTALL as sysdba;
@$ORACLE_HOME/rdbms/admin/standard.sql
@$ORACLE_HOME/rdbms/admin/catalog.sql
@$ORACLE_HOME/rdbms/admin/catproc.sql
@/ata2/CREATE_DB/01_create_ACQ1_profile.sql
@/ata2/CREATE_DB/02_create_ACQ1_tablespaces.sql
@/ata2/CREATE_DB/03_create_ACQ1_users.sql
@/ata2/CREATE_DB/04_grant_ACQ1_role_privileges.sql

connect SYSTEM/manager;
@$ORACLE_HOME/sqlplus/admin/pupbld.sql

connect prod_usr/itec1111;
@/ata2/CREATE_DB/05_create_DATABASE_LINK.sql

connect / as sysdba;
@/ata2/CREATE_DB/06_rename_GLOBAL_NAME.sql
@/ata2/CREATE_DB/07_create_SPFILE.sql

spool off
exit
EOF

Dependency sub-scripts of 'Create_ACQ1_DB.sh' are located at /ata2/CREATE_DB/:-

/ata2/CREATE_DB [ACQ1]>> ls -lrt
total 120
-rwxr-xr-x 1 oracle dba 2225 Jun 18 13:49 Remove_Existing_DB_Files.sh
-rwxr-xr-x 1 oracle dba 1443 Jun 18 13:52 01_create_ACQ1_profile.sql
-rwxr-xr-x 1 oracle dba 25915 Jun 18 13:53 02_create_ACQ1_tablespaces.sql
-rwxr-xr-x 1 oracle dba 1662 Jun 18 13:53 03_create_ACQ1_users.sql
-rwxr-xr-x 1 oracle dba 1373 Jun 18 13:53 04_grant_ACQ1_role_privileges.sql
-rwxr-xr-x 1 oracle dba 319 Jun 18 13:53 05_create_DATABASE_LINK.sql
-rw-r--r-- 1 oracle dba 267 Jun 18 13:54 06_rename_GLOBAL_NAME.sql
-rw-r--r-- 1 oracle dba 275 Jun 18 13:58 07_create_SPFILE.sql
-rwxr-xr-x 1 oracle dba 3290 Jun 18 13:59 Create_ACQ1_DB.sh
drwxr-xr-x 2 oracle dba 256 Jun 18 15:54 LOGS

The '01_create_ACQ1_profile.sql'

-- Job Seq : 01
-- Author : Natalie
-- Date Create : 02/06/2009
-- Sscript Name: 01_create_ACQ1_profile.sql
-- Purpose : ACQ1 Profile Creation
--
CREATE PROFILE "INQ_PROFILE"
LIMIT
COMPOSITE_LIMIT DEFAULT
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL DEFAULT
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL DEFAULT
IDLE_TIME DEFAULT
CONNECT_TIME DEFAULT
PRIVATE_SGA DEFAULT
FAILED_LOGIN_ATTEMPTS DEFAULT
PASSWORD_LIFE_TIME DEFAULT
PASSWORD_REUSE_TIME DEFAULT
PASSWORD_REUSE_MAX DEFAULT
PASSWORD_LOCK_TIME DEFAULT
PASSWORD_GRACE_TIME DEFAULT;

CREATE PROFILE "PROD_PROFILE"
LIMIT
COMPOSITE_LIMIT DEFAULT
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL DEFAULT
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL DEFAULT
IDLE_TIME DEFAULT
CONNECT_TIME DEFAULT
PRIVATE_SGA DEFAULT
FAILED_LOGIN_ATTEMPTS DEFAULT
PASSWORD_LIFE_TIME DEFAULT
PASSWORD_REUSE_TIME DEFAULT
PASSWORD_REUSE_MAX DEFAULT
PASSWORD_LOCK_TIME DEFAULT
PASSWORD_GRACE_TIME DEFAULT;

CREATE PROFILE "USER_PROFILE"
LIMIT
COMPOSITE_LIMIT DEFAULT
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL DEFAULT
LOGICAL_READS_PER_SESSION DEFAULT
LOGICAL_READS_PER_CALL DEFAULT
IDLE_TIME DEFAULT
CONNECT_TIME DEFAULT
PRIVATE_SGA DEFAULT
FAILED_LOGIN_ATTEMPTS DEFAULT
PASSWORD_LIFE_TIME DEFAULT
PASSWORD_REUSE_TIME DEFAULT
PASSWORD_REUSE_MAX DEFAULT
PASSWORD_LOCK_TIME DEFAULT
PASSWORD_GRACE_TIME DEFAULT;

The '02_create_ACQ1_tablespaces.sql'

-- Job Seq : 02
-- Author : Natalie
-- Date Create : 02/06/2009
-- Sscript Name: 02_create_ACQ1_tablespaces.sql
-- Purpose : Creation of ACQ1 Tablespace
--

CREATE TABLESPACE "TMPRY01" DATAFILE
'/disk21/oradata/ACQ1/tmpry01_01.dbf' SIZE 524288000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE UNDO TABLESPACE "UNDO_TBS02" DATAFILE
'/disk16/oradata/ACQ1/undo_tbs02.dbf' SIZE 1048576000 REUSE AUTOEXTEND ON;

CREATE TABLESPACE "INTCHG01" DATAFILE
'/disk10/oradata/ACQ1/intchg01_01.dbf' SIZE 814743552 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2048000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "INTCHG02" DATAFILE
'/disk17/oradata/ACQ1/intchg02_01.dbf' SIZE 2306867200 REUSE ,
'/disk16/oradata/ACQ1/intchg02_02.dbf' SIZE 2097152000 REUSE ,
'/disk18/oradata/ACQ1/intchg02_03.dbf' SIZE 2097152000 REUSE ,
'/disk18/oradata/ACQ1/intchg02_04.dbf' SIZE 2097152000 REUSE ,
'/disk18/oradata/ACQ1/intchg02_05.dbf' SIZE 3097152000 REUSE ,
'/disk19/oradata/ACQ1/intchg02_06.dbf' SIZE 3145728000 REUSE ,
'/disk13/oradata/ACQ1/intchg02_07.dbf' SIZE 3145728000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5120000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "INTCHG03" DATAFILE
'/disk16/oradata/ACQ1/intchg03_01.dbf' SIZE 524288000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "INTCHG04" DATAFILE
'/disk15/oradata/ACQ1/intchg04_01.dbf' SIZE 52428800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "INTCHG05" DATAFILE
'/disk14/oradata/ACQ1/intchg05_01.dbf' SIZE 52428800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERC01" DATAFILE
'/disk11/oradata/ACQ1/merc01_01.dbf' SIZE 954204160 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2048000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERC02" DATAFILE
'/disk17/oradata/ACQ1/merc02_01.dbf' SIZE 1887436800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5120000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERC03" DATAFILE
'/disk10/oradata/ACQ1/merc03_01.dbf' SIZE 1887436800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2048000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERC04" DATAFILE
'/disk14/oradata/ACQ1/merc04_01.dbf' SIZE 3670016000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERC05" DATAFILE
'/disk15/oradata/ACQ1/merc05_01.dbf' SIZE 209715200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERC06" DATAFILE
'/disk16/oradata/ACQ1/merc06_01.dbf' SIZE 209715200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMMTD01" DATAFILE
'/disk10/oradata/ACQ1/pmmtd01_01.dbf' SIZE 209715200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "RPT01" DATAFILE
'/disk18/oradata/ACQ1/rpt01_01.dbf' SIZE 448790528 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5120000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "RPT02" DATAFILE
'/disk19/oradata/ACQ1/rpt02_01.dbf' SIZE 524288000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "RPT03" DATAFILE
'/disk20/oradata/ACQ1/rpt03_01.dbf' SIZE 209715200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "RPT04" DATAFILE
'/disk21/oradata/ACQ1/rpt04_01.dbf' SIZE 291504128 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SEC01" DATAFILE
'/disk9/oradata/ACQ1/sec01_01.dbf' SIZE 2097152000 REUSE ,
'/disk10/oradata/ACQ1/sec01_02.dbf' SIZE 301989888 REUSE ,
'/disk11/oradata/ACQ1/sec01_03.dbf' SIZE 2097152000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SEC02" DATAFILE
'/disk8/oradata/ACQ1/sec02_01.dbf' SIZE 524288000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SEC03" DATAFILE
'/disk16/oradata/ACQ1/sec03_01.dbf' SIZE 52428800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SEC04" DATAFILE
'/disk6/oradata/ACQ1/sec04_01.dbf' SIZE 52428800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETT01" DATAFILE
'/disk10/oradata/ACQ1/sett01_01.dbf' SIZE 972029952 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETT02" DATAFILE
'/disk8/oradata/ACQ1/sett02_01.dbf' SIZE 816840704 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5120000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETT03" DATAFILE
'/disk12/oradata/ACQ1/sett03_01.dbf' SIZE 267386880 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2048000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETT04" DATAFILE
'/disk13/oradata/ACQ1/sett04_01.dbf' SIZE 399507456 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETT05" DATAFILE
'/disk14/oradata/ACQ1/sett05_01.dbf' SIZE 314572800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETT06" DATAFILE
'/disk15/oradata/ACQ1/sett06_01.dbf' SIZE 524288000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "VINTCHG01" DATAFILE
'/disk13/oradata/ACQ1/vintchg01_01.dbf' SIZE 655360000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5120000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "VINTCHG02" DATAFILE
'/disk8/oradata/ACQ1/vintchg02_01.dbf' SIZE 249561088 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "VINTCHG03" DATAFILE
'/disk16/oradata/ACQ1/vintchg03_01.dbf' SIZE 59768832 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2048000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "VINTCHG04" DATAFILE
'/disk10/oradata/ACQ1/vintchg04_01.dbf' SIZE 104857600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "VINTCHG05" DATAFILE
'/disk11/oradata/ACQ1/vintchg05_01.dbf' SIZE 52428800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "WEB01" DATAFILE
'/disk20/oradata/ACQ1/web01_01.dbf' SIZE 155189248 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "WEB02" DATAFILE
'/disk21/oradata/ACQ1/web02_01.dbf' SIZE 52428800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PHSLP01" DATAFILE
'/disk15/oradata/ACQ1/phslp01_01.dbf' SIZE 2097152000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PHSLP02" DATAFILE
'/disk8/oradata/ACQ1/phslp02_01.dbf' SIZE 2097152000 REUSE ,
'/disk9/oradata/ACQ1/phslp02_02.dbf' SIZE 2097152000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PHSLP03" DATAFILE
'/disk10/oradata/ACQ1/phslp03_01.dbf' SIZE 2097152000 REUSE ,
'/disk11/oradata/ACQ1/phslp03_02.dbf' SIZE 2097152000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PHSLP04" DATAFILE
'/disk12/oradata/ACQ1/phslp04_01.dbf' SIZE 2097152000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PHSLP05" DATAFILE
'/disk13/oradata/ACQ1/phslp05_01.dbf' SIZE 2097152000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PHSLP06" DATAFILE
'/disk14/oradata/ACQ1/phslp06_01.dbf' SIZE 2097152000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PHSLP07" DATAFILE
'/disk15/oradata/ACQ1/phslp07_01.dbf' SIZE 2097152000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "INTCHGX01" DATAFILE
'/disk10/oradata/ACQ1/intchgx01_01.dbf' SIZE 419430400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2048000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "INTCHGX02" DATAFILE
'/disk17/oradata/ACQ1/intchgx02_01.dbf' SIZE 2097152000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5120000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "INTCHGX03" DATAFILE
'/disk16/oradata/ACQ1/intchgx03_01.dbf' SIZE 188743680 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "INTCHGX04" DATAFILE
'/disk15/oradata/ACQ1/intchgx04_01.dbf' SIZE 26214400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "INTCHGX05" DATAFILE
'/disk14/oradata/ACQ1/intchgx05_01.dbf' SIZE 26214400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERCX01" DATAFILE
'/disk11/oradata/ACQ1/mercx01_01.dbf' SIZE 471859200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERCX02" DATAFILE
'/disk17/oradata/ACQ1/mercx02_01.dbf' SIZE 419430400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5120000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERCX03" DATAFILE
'/disk10/oradata/ACQ1/mercx03_01.dbf' SIZE 178257920 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2048000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERCX04" DATAFILE
'/disk14/oradata/ACQ1/mercx04_01.dbf' SIZE 629145600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERCX05" DATAFILE
'/disk15/oradata/ACQ1/mercx05_01.dbf' SIZE 104857600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "MERCX06" DATAFILE
'/disk16/oradata/ACQ1/mercx06_01.dbf' SIZE 104857600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PHSLPX01" DATAFILE
'/disk11/oradata/ACQ1/phslpx01_01.dbf' SIZE 2097152000 REUSE ,
'/disk12/oradata/ACQ1/phslpx01_02.dbf' SIZE 2097152000 REUSE ,
'/disk13/oradata/ACQ1/phslpx01_03.dbf' SIZE 2097152000 REUSE ,
'/disk14/oradata/ACQ1/phslpx01_04.dbf' SIZE 2097152000 REUSE ,
'/disk15/oradata/ACQ1/phslpx01_05.dbf' SIZE 2097152000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMHTRX01" DATAFILE
'/disk12/oradata/ACQ1/pmhtrx01_01.dbf' SIZE 1572864000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMMTDX01" DATAFILE
'/disk14/oradata/ACQ1/pmmtdx01_01.dbf' SIZE 629145600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMPYSX01" DATAFILE
'/disk15/oradata/ACQ1/pmpysx01_01.dbf' SIZE 1363148800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "RPTX01" DATAFILE
'/disk18/oradata/ACQ1/rptx01_01.dbf' SIZE 220200960 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5120000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "RPTX02" DATAFILE
'/disk19/oradata/ACQ1/rptx02_01.dbf' SIZE 209715200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "RPTX03" DATAFILE
'/disk20/oradata/ACQ1/rptx03_01.dbf' SIZE 104857600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "RPTX04" DATAFILE
'/disk21/oradata/ACQ1/rptx04_01.dbf' SIZE 157286400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SECX01" DATAFILE
'/disk9/oradata/ACQ1/secx01_01.dbf' SIZE 2097152000 REUSE ,
'/disk10/oradata/ACQ1/secx01_02.dbf' SIZE 2097152000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SECX02" DATAFILE
'/disk8/oradata/ACQ1/secx02_01.dbf' SIZE 104857600 REUSE ,
'/disk3/oradata/ACQ1/secx02_02.dbf' SIZE 104857600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SECX03" DATAFILE
'/disk16/oradata/ACQ1/secx03_01.dbf' SIZE 26214400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SECX04" DATAFILE
'/disk6/oradata/ACQ1/secx04_01.dbf' SIZE 104857600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETTX01" DATAFILE
'/disk10/oradata/ACQ1/settx01_01.dbf' SIZE 524288000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETTX02" DATAFILE
'/disk8/oradata/ACQ1/settx02_01.dbf' SIZE 367001600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5120000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETTX03" DATAFILE
'/disk12/oradata/ACQ1/settx03_01.dbf' SIZE 293601280 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2048000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETTX04" DATAFILE
'/disk13/oradata/ACQ1/settx04_01.dbf' SIZE 209715200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETTX05" DATAFILE
'/disk14/oradata/ACQ1/settx05_01.dbf' SIZE 104857600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "SETTX06" DATAFILE
'/disk15/oradata/ACQ1/settx06_01.dbf' SIZE 157286400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "VINTCHGX01" DATAFILE
'/disk13/oradata/ACQ1/vintchgx01_01.dbf' SIZE 367001600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 5120000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "VINTCHGX02" DATAFILE
'/disk8/oradata/ACQ1/vintchgx02_01.dbf' SIZE 125829120 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "VINTCHGX03" DATAFILE
'/disk16/oradata/ACQ1/vintchgx03_01.dbf' SIZE 104857600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 2048000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "VINTCHGX04" DATAFILE
'/disk10/oradata/ACQ1/vintchgx04_01.dbf' SIZE 26214400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "VINTCHGX05" DATAFILE
'/disk11/oradata/ACQ1/vintchgx05_01.dbf' SIZE 26214400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "WEBX01" DATAFILE
'/disk20/oradata/ACQ1/webx01_01.dbf' SIZE 73400320 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1024000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "WEBX02" DATAFILE
'/disk21/oradata/ACQ1/webx02_01.dbf' SIZE 26214400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMHTR01" DATAFILE
'/disk12/oradata/ACQ1/pmhtr01_01.dbf' SIZE 419430400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMHTR02" DATAFILE
'/disk13/oradata/ACQ1/pmhtr02_01.dbf' SIZE 524288000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMHTR03" DATAFILE
'/disk15/oradata/ACQ1/pmhtr03_01.dbf' SIZE 734003200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMHTR04" DATAFILE
'/disk16/oradata/ACQ1/pmhtr04_01.dbf' SIZE 524288000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMHTR05" DATAFILE
'/disk17/oradata/ACQ1/pmhtr05_01.dbf' SIZE 419430400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMHTR06" DATAFILE
'/disk11/oradata/ACQ1/pmhtr06_01.dbf' SIZE 524288000 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMHTR07" DATAFILE
'/disk10/oradata/ACQ1/pmhtr07_01.dbf' SIZE 419430400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMMTD02" DATAFILE
'/disk11/oradata/ACQ1/pmmtd02_01.dbf' SIZE 314572800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMMTD03" DATAFILE
'/disk12/oradata/ACQ1/pmmtd03_01.dbf' SIZE 314572800 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMMTD04" DATAFILE
'/disk13/oradata/ACQ1/pmmtd04_01.dbf' SIZE 209715200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMMTD05" DATAFILE
'/disk14/oradata/ACQ1/pmmtd05_01.dbf' SIZE 209715200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMMTD06" DATAFILE
'/disk15/oradata/ACQ1/pmmtd06_01.dbf' SIZE 209715200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMMTD07" DATAFILE
'/disk16/oradata/ACQ1/pmmtd07_01.dbf' SIZE 209715200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMPYS01" DATAFILE
'/disk6/oradata/ACQ1/pmpys01_01.dbf' SIZE 419430400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMPYS02" DATAFILE
'/disk15/oradata/ACQ1/pmpys02_01.dbf' SIZE 734003200 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMPYS03" DATAFILE
'/disk8/oradata/ACQ1/pmpys03_01.dbf' SIZE 419430400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMPYS04" DATAFILE
'/disk9/oradata/ACQ1/pmpys04_01.dbf' SIZE 419430400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMPYS05" DATAFILE
'/disk10/oradata/ACQ1/pmpys05_01.dbf' SIZE 419430400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMPYS06" DATAFILE
'/disk11/oradata/ACQ1/pmpys06_01.dbf' SIZE 419430400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "PMPYS07" DATAFILE
'/disk12/oradata/ACQ1/pmpys07_01.dbf' SIZE 419430400 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10240000 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "TMPRYX01" DATAFILE
'/disk21/oradata/ACQ1/tmpryx01_01.dbf' SIZE 83886080 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "STPACK" DATAFILE
'/disk18/oradata/ACQ1/stpack_01.dbf' SIZE 20971520 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "ADMIN" DATAFILE
'/disk18/oradata/ACQ1/admin_01.dbf' SIZE 104857600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TABLESPACE "ADMINX" DATAFILE
'/disk18/oradata/ACQ1/adminx_01.dbf' SIZE 104857600 REUSE
NOLOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 102400 SEGMENT SPACE MANAGEMENT MANUAL;

CREATE TEMPORARY TABLESPACE "VERITAS_I3_ORCL_TMP" TEMPFILE
'/disk18/oradata/ACQ1/VERITAS_I3_ORCL_TMP.dbf' SIZE 20971520 REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 65536;

CREATE TABLESPACE "PERFSTAT" DATAFILE
'/disk15/oradata/ACQ1/PERFSTAT.dbf' SIZE 734003200 REUSE
LOGGING ONLINE PERMANENT BLOCKSIZE 4096
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;

-- Below SYSTEM tablespace already exits during DB creation
----- CREATE TABLESPACE "SYSTEM" DATAFILE
----- '/disk16/oradata/ACQ1/systemACQ101.dbf' SIZE 2621440000 REUSE
----- AUTOEXTEND ON NEXT 10485760 MAXSIZE UNLIMITED
----- LOGGING ONLINE PERMANENT BLOCKSIZE 4096
----- EXTENT MANAGEMENT DICTIONARY MINIMUM EXTENT 0 DEFAULT NOCOMPRESS
----- STORAGE(INITIAL 12288 NEXT 12288 MINEXTENTS 1 MAXEXTENTS 249
----- PCTINCREASE 50);

-- Below Temp tablesapce already exits during DB creation
----- CREATE TEMPORARY TABLESPACE "TEMP" TEMPFILE
----- '/disk15/oradata/ACQ1/temp01.dbf' SIZE 3145728000 REUSE ,
----- '/disk8/oradata/ACQ1/temp02.dbf' SIZE 3145728000 REUSE ,
----- '/disk9/oradata/ACQ1/temp03.dbf' SIZE 2097152000 REUSE
----- EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576;

----- CREATE TEMPORARY TABLESPACE "TEMP1" TEMPFILE
----- '/disk15/oradata/ACQ1/temp1_01.dbf' SIZE 10485760 REUSE
----- EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1048576;

-- Below Undo tablespaces already exits during DB creation
----- CREATE UNDO TABLESPACE "UNDO_TBS01" DATAFILE
----- '/disk8/oradata/ACQ1/undo_tbs01.dbf' SIZE 2097152000 REUSE
----- AUTOEXTEND ON NEXT 5242880 MAXSIZE UNLIMITED
----- BLOCKSIZE 4096
----- EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT MANUAL;

The '03_create_ACQ1_users.sql'

-- Job Seq : 03
-- Author : Natalie
-- Date Create : 02/06/2009
-- Sscript Name: 03_create_ACQ1_users.sql
-- Purpose : ACQ1 User ID Creation

ALTER USER SYSTEM IDENTIFIED BY manager;

CREATE USER "PROD_USR" IDENTIFIED BY itec1111
DEFAULT TABLESPACE "TMPRY01"
TEMPORARY TABLESPACE "TEMP01"
PROFILE "PROD_PROFILE";

CREATE USER "USER1" IDENTIFIED BY VALUES 'FE8345BD921AEFC1'
DEFAULT TABLESPACE "TMPRY01"
TEMPORARY TABLESPACE "TEMP01"
PROFILE "USER_PROFILE";

CREATE USER "USER2" IDENTIFIED BY VALUES 'B68129D763CAF1E1'
DEFAULT TABLESPACE "TMPRY01"
TEMPORARY TABLESPACE "TEMP01"
PROFILE "USER_PROFILE";

CREATE USER "USER3" IDENTIFIED BY VALUES 'C30F753302B7A583'
DEFAULT TABLESPACE "TMPRY01"
TEMPORARY TABLESPACE "TEMP01"
PROFILE "USER_PROFILE";

CREATE USER "INQ_USR" IDENTIFIED BY VALUES 'C639016B3635ABBC'
DEFAULT TABLESPACE "TMPRY01"
TEMPORARY TABLESPACE "TEMP01"
PROFILE "INQ_PROFILE";

CREATE USER "DUAL_USR" IDENTIFIED BY VALUES '7CF548B6FAF7CE35'
TEMPORARY TABLESPACE "TEMP01";

CREATE USER "PROGNOSIS" IDENTIFIED BY VALUES '2DFD170A0C58CED3'
TEMPORARY TABLESPACE "TEMP01";

CREATE USER "PERFSTAT" IDENTIFIED BY VALUES 'AC98877DE1297365'
DEFAULT TABLESPACE "PERFSTAT"
TEMPORARY TABLESPACE "TEMP01";

-- CREATE USER "OUTLN" IDENTIFIED BY VALUES '4A3BA55E08595C81'
-- TEMPORARY TABLESPACE "TEMP01"
-- PASSWORD EXPIRE
-- ACCOUNT LOCK;

-- CREATE USER "WMSYS" IDENTIFIED BY VALUES '7C9BA362F8314299'
-- TEMPORARY TABLESPACE "TEMP01"
-- PASSWORD EXPIRE
-- ACCOUNT LOCK;

The '04_grant_ACQ1_role_privileges.sql'

-- Job Seq : 04
-- Author : Natalie
-- Date Create : 02/06/2009
-- Sscript Name: 04_grant_ACQ1_role_privileges.sql
-- Purpose : Grant user role and privileges
--

-- User Role
GRANT "DBA" TO "PROD_USR";

-- User System Privileges
GRANT SELECT ANY DICTIONARY TO "PROD_USR";
GRANT CREATE TYPE TO "PROD_USR";
GRANT CREATE PROCEDURE TO "PROD_USR";
GRANT CREATE DATABASE LINK TO "PROD_USR";
GRANT CREATE SEQUENCE TO "PROD_USR";
GRANT CREATE VIEW TO "PROD_USR";
GRANT DROP PUBLIC SYNONYM TO "PROD_USR";
GRANT CREATE PUBLIC SYNONYM TO "PROD_USR";
GRANT CREATE SYNONYM TO "PROD_USR";
GRANT CREATE TABLE TO "PROD_USR";
GRANT UNLIMITED TABLESPACE TO "PROD_USR";
GRANT CREATE SESSION TO "PROD_USR";
GRANT CREATE TABLESPACE TO PROD_USR;
GRANT CREATE ANY VIEW TO PROD_USR;
GRANT CREATE ANY TYPE TO PROD_USR;
GRANT CREATE ANY INDEX TO PROD_USR;
GRANT CREATE ANY TABLE TO PROD_USR;
GRANT ALTER TABLESPACE TO PROD_USR;
GRANT ALTER ANY INDEX TO PROD_USR;
GRANT ALTER ANY TABLE TO PROD_USR;
GRANT UPDATE ANY TABLE TO PROD_USR;
GRANT SELECT ANY TABLE TO PROD_USR;
GRANT SELECT ANY DICTIONARY TO PROD_USR WITH ADMIN OPTION;
GRANT DROP ANY INDEX TO PROD_USR;
GRANT DROP ANY VIEW TO PROD_USR;
GRANT DROP ANY TYPE TO PROD_USR;
GRANT DROP ANY TABLE TO PROD_USR;
GRANT DELETE ANY TABLE TO PROD_USR;
GRANT DROP TABLESPACE TO PROD_USR;
GRANT DROP PUBLIC DATABASE LINK TO PROD_USR;

The '05_create_DATABASE_LINK.sql'

-- Job Seq : 02
-- Author : Natalie
-- Date Create : 02/06/2009
-- Sscript Name: 05_create_DATABASE_LINK.sql
-- Purpose : Create DATABASE Link
--

SELECT * FROM ALL_DB_LINKS;
CREATE PUBLIC DATABASE LINK ISS1.WORLD CONNECT to prod_usr IDENTIFIED BY itec1111 using 'ISS1.WORLD';
SELECT * FROM ALL_DB_LINKS;

The '06_rename_GLOBAL_NAME.sql'

-- Job Seq : 06
-- Author : Natalie
-- Date Create : 02/06/2009
-- Sscript Name: 06_rename_GLOBAL_NAME.sql
-- Purpose : Renme Database Global Name
--

SELECT * FROM GLOBAL_NAME;
ALTER DATABASE RENAME GLOBAL_NAME TO ACQ1.WORLD;
SELECT * FROM GLOBAL_NAME;

The '07_create_SPFILE.sql'

-- Job Seq : 07
-- Author : Natalie
-- Date Create : 02/06/2009
-- Sscript Name: 07_create_PFILE.sql
-- Purpose : Create SPFILE as a backup
-- When the SPFILE is created ,you may go to $ORACLE_HOME/dbs/ to check the 'spfileACQ1.ora'
--
create spfile from pfile;

5. Once the ACQ1 DB has successful created, you may now proceed to import the ACQ1 *.dmp data into this new DB.