| 0 comments ]

LPAR1 PROD DB – ACQ1 DMP BACKUP LOCATION:-
·        Production Database Backup job is executed by operator daily after batch job completed.
Database Backup job was located at /export/home/orabkup.
Main Script name:-oramain
Sub-Script name: - BCKALLDB
·        The Backup Job will be housekeep those existing backup files before it proceed to the backup.
·        The backup will be stored at below location:-
/ata2/EXPDMP/

/export/home/orabkup/EXP > ls -lrt /*/EXPDMP/acq*  /*/EXPDMP/expallacq.log
-rw-r-----   1 orabkup  dba       142828160 Jun 06 19:22 /ata2/EXPDMP/acqgrp01.dmp.gz
-rw-r-----   1 orabkup  dba       140601272 Jun 06 19:23 /ata2/EXPDMP/acqgrp02.dmp.gz
-rw-r-----   1 orabkup  dba       175322424 Jun 06 19:24 /ata2/EXPDMP/acqgrp03.dmp.gz
-rw-r-----   1 orabkup  dba       299426662 Jun 06 19:25 /ata2/EXPDMP/acqgrp04.dmp.gz
-rw-r-----   1 orabkup  dba       229430165 Jun 06 19:26 /ata2/EXPDMP/acqgrp05.dmp.gz
-rw-r-----   1 orabkup  dba       386247009 Jun 06 19:28 /ata2/EXPDMP/acqgrp06.dmp.gz
-rw-r-----   1 orabkup  dba       545863608 Jun 06 19:29 /ata2/EXPDMP/acqgrp07.dmp.gz
-rw-r-----   1 orabkup  dba       437091817 Jun 06 19:30 /ata2/EXPDMP/acqgrp08.dmp.gz
-rw-r-----   1 orabkup  dba       239622550 Jun 06 19:31 /ata2/EXPDMP/acqgrp09.dmp.gz
-rw-r-----   1 orabkup  dba       316071138 Jun 06 19:33 /ata2/EXPDMP/acqgrp10.dmp.gz
-rw-r-----   1 orabkup  dba       413829409 Jun 06 19:34 /ata2/EXPDMP/acqgrp11.dmp.gz
-rw-r-----   1 orabkup  dba           76285 Jun 06 19:35 /ata2/EXPDMP/expallacq.log
-rw-r-----   1 orabkup  dba       157802121 Jun 06 19:35 /ata2/EXPDMP/acqgrp12.dmp.gz
/export/home/orabkup/EXP >
When the Management has declared the Disaster Recovery Simulation Date & Business Date, you should start to backup the production DB dmp files in to safe location. Please refer to below steps.

  • Due to ftp process may take 1-2 days to be completed, you should move the production backup (Refer DR business Date) into safe place to avoid the daily backup being housekeep.
Login as oracle
cd /ata1/DRPREPARE

Execute below job:-
01_JSAFEDMP 

  • Once the Prod DB dmp files being moved to the safe place /ata1/ DRBCKUP, you may proceed to run the ftp job in background. FTP process may take about 1-2 days to be completed and it will cause the DR server getting slower, please acknowledge the applications team when you are running ftp process for DR purpose.
cd /ata1/DRPREPARE and execute below command:-

nohup sh 02_JFTP-01-03 -print  /ata1/DRPREPARE/LOGS/JFTP-01-03.log &   [Press Enter]
nohup sh 02_JFTP-04-06 -print  /ata1/DRPREPARE/LOGS/JFTP-04-06.log &   [Press Enter]
nohup sh 02_JFTP-07-09 -print  /ata1/DRPREPARE/LOGS/JFTP-07-09.log &   [Press Enter]
nohup sh 02_JFTP-10-15 -print  /ata1/DRPREPARE/LOGS/JFTP-10-15.log &   [Press Enter]
  • When the ftp process has completed, check all the dmp files and ensure all the required dmp files are in place at DR server.
ls -lrt /*/ACQDMP/acqgrp*    /*/ACQDMP/ expallacq.log

  • Unzip the /*/ACQDMP/acqgrp*.dmp.gz
EXAMPLE:-
gunzip /*/ACQDMP/acqgrp*.dmp.gz


 In order to perform DR DB restorations please follow the following steps accordingly.

1.)    TURNOFF archive log mode for DR ACQ1.
EXAMPLE:
Telnet 10.96.21.17
Connect to LPAR1 DR DB ACQ1
Logon as oracle
export ORACLE_SID=ACQ1
/export/home/oracle/oracle9.2.0 [ACQ1]>> sqlplus 'sys as sysdba'

SQL*Plus: Release 9.2.0.5.0 - Production on Mon Jun 7 14:33:28 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

SQL>

Check the Archive Log Mode:-
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            /disk5/ARCHIVELOG
Oldest online log sequence     2463
Next log sequence to archive   2465
Current log sequence           2465

To turn off the Archive Log Mode, execute below command accordingly.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mount
ORACLE instance started.

Total System Global Area 2148831320 bytes
Fixed Size                   745560 bytes
Variable Size            1811939328 bytes
Database Buffers          335544320 bytes
Redo Buffers                 602112 bytes
Database mounted.


SQL> Alter database noarchivelog;
 
Database altered.

SQL> Alter database open;

Database altered.

SQL>
2.)    Telnet to DR server 10.96.21.17
3.)    Connect to DR DB ACQ1 database.
Logon as oracle
Export ORACLE_SID=ACQ1

EXAMPLE:-
/export/home/oracle/oracle9.2.0 [ACQ]>> export ORACLE_SID=ACQ1
/export/home/oracle/oracle9.2.0 [ACQ1]>> sqlplus 'prod_usr'

SQL*Plus: Release 9.2.0.5.0 - Production on Mon Jun 7 14:36:50 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.5.0 - Production

SQL> select table_name from user_tables;

  • Drop all the OLD tables from DR ACQ1 database.
  • Before Import DB, you have to alter the parameter file, ensure the dmp files location is correct and the tables name is accordingly to the Backup tables’ name.
  • The import parameter file is located at /ata2/script/impdb and the parameter file is impallacq.par
  • Those lines that are highlighted in red, you may need to ensure it pointed to the correct location.
  • Those lines that are highlighted in green, you may need to alter as per the production backup table list which is located at /ata1/ACQDMP/ and the prod table name is expallacq.log

userid=prod_usr/itec9830
BUFFER=1000
FILESIZE=2048000000
FILE=/ata1/ACQDMP/acqgrp01.dmp,
/ata1/ACQDMP/acqgrp02.dmp, \
/ata1/ACQDMP/acqgrp03.dmp, \
/ata1/ACQDMP/acqgrp04.dmp, \
/ata2/ACQDMP/acqgrp05.dmp, \
/ata2/ACQDMP/acqgrp06.dmp, \
/ata2/ACQDMP/acqgrp07.dmp, \
/ata2/ACQDMP/acqgrp08.dmp, \
/disk21/ACQDMP/acqgrp09.dmp, \
/disk21/ACQDMP/acqgrp10.dmp, \
/disk21/ACQDMP/acqgrp11.dmp
IGNORE=Y
GRANTS=N
STATISTICS=NONE
LOG=/ata2/script/impdb/impallacq<import_date>.log
TABLES=(ASE007DK    , \
ASE009DK    , \
ASE010DK    , \
ASE011DK    , \
ASE012DK    , \
ASE013DK    , \
ASE015DK    , \
ASE016DK    , \
ASE018DK    , \
.
.
.
TPICANO     , \
TPMERTRX    , \
TSE006DK)
     
4.)    execute below command to run the backup into background
EXAMPLE:-
telnet 10.96.21.17
Logon oracle
 /ata2/script/impdb
nohup imp parfile=impallacq.par  & [press enter]
or
nohup sh impallacq.sh &  [press enter]
See below output example:-
/ata2/script/impdb [ACQ1]>> nohup imp parfile=impallacq.par  &
Sending nohup output to nohup.out.
[1]     1597548
/ata2/script/impdb [ACQ1]>>

/ata2/script/impdb [ACQ1]>> nohup sh impallacq.sh &
[1]     1183920
/ata2/script/impdb [ACQ1]>> Sending nohup output to nohup.out.
/ata2/script/impdb [ACQ1]>>

You may tail the log and check to ensure the imp is running in progress without error:-
See below output example:-
/ata2/script/impdb [ACQ1]>> tail -f nohup.out
JServer Release 9.2.0.5.0 - Production

Export file created by EXPORT:V09.02.00 via direct path
import done in US7ASCII character set and AL16UTF16 NCHAR character set
. importing PROD_USR's objects into PROD_USR
. . importing table                     "ASE007DK"        326 rows imported
. . importing table                     "ASE009DK"         42 rows imported
. . importing table                     "ASE010DK"        166 rows imported
. . importing table                     "ASE011DK"        975 rows imported
. . importing table                     "ASE012DK"      89241 rows imported
. . importing table                     "ASE013DK"     145959 rows imported
. . importing table                     "ASE015DK"          0 rows imported
. . importing table                     "ASE016DK"         76 rows imported
. . importing table                     "ASE018DK"         12 rows imported
. . importing table                     "ASE021DK"          0 rows imported
. . importing table                      "FAJCIPM"      29267 rows imported
. . importing table                      "FAJCSEQ"          1 rows imported
. . importing table                      "FAMCIPM"
5.)    Grant privileges.
grant select,update,delete, insert on to user1,user2;
grant select on to inq_usr;
grant select on to user1,user2;

6.)    Important update devp LPAR1 ACQ1 table RSE006DK > set password last change date to future date. If the Password last change date is expired date the system will keep popping up the Change Password screen.
EXAMPLE:-
SQL> desc rse006dk;
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 VG_XRSE006_HDR_USER_ID                    NOT NULL CHAR(8)
 VG_QRSE006_CREATE_TIMESTAMP               NOT NULL NUMBER(17)
 VG_QRSE006_UPDATE_TIMESTAMP               NOT NULL NUMBER(17)
 VG_XRSE006_USER_ID                        NOT NULL CHAR(8)
 VG_XRSE006_GROUP_ID                       NOT NULL CHAR(8)
 VG_XRSE006_DEPT_ID                        NOT NULL CHAR(2)
 VG_XRSE006_USER_NAME                      NOT NULL CHAR(30)
 VG_XRSE006_PASSWORD                       NOT NULL CHAR(8)
 VG_9RSE006_LOGON_LOCK                     NOT NULL NUMBER(1)
 VG_9RSE006_ALLOWABLE_SESSION              NOT NULL NUMBER(2)
 VG_9RSE006_PW_LAST_CHG_DATE               NOT NULL NUMBER(8)
 VG_NRSE006_LOGON_SESSION                  NOT NULL NUMBER(4)
 VG_NRSE006_LOGON_ATTEMPTED                NOT NULL NUMBER(4)
 VG_QRSE006_L_LGN_TIMESTAMP                NOT NULL NUMBER(17)
 VG_QRSE006_F_LGN_TIMESTAMP                NOT NULL NUMBER(17)
 VG_9RSE006_PW_COUNTER                     NOT NULL NUMBER(3)
 VG_XRSE006_USER_STATUS                    NOT NULL CHAR(1)
 VG_9RSE006_EXPIRY_DATE                    NOT NULL NUMBER(8)
 VG_9RSE006_DISABLE                        NOT NULL NUMBER(1)
 VG_9RSE006_ACCESS_GROUP                   NOT NULL NUMBER(2)
 VG_9RSE006_BROKER_ID                      NOT NULL NUMBER(4)
 VG_9RSE006_BROKER_BRANCH                  NOT NULL NUMBER(3)
 VG_XRSE006_L_LGN_TERM                     NOT NULL CHAR(8)
 VG_9RSE006_FI_CODE                        NOT NULL NUMBER(6)
 VG_XRSE006_DIS_RT_PRI                     NOT NULL CHAR(1)
 VG_XRSE006_ORACLE_USR_ID                  NOT NULL CHAR(8)
 VG_XRSE006_ORACLE_SID                     NOT NULL CHAR(5)
 VG_9RSE006_LOC_ACCESS_GRP                 NOT NULL NUMBER(2)

SQL> select VG_9RSE006_PW_LAST_CHG_DATE from rse006dk where VG_XRSE006_GROUP_ID='ITGRP6' and VG_XRSE006_USER_ID='NATALIE';

VG_9RSE006_PW_LAST_CHG_DATE
---------------------------
                   20090901
Below example are updating 1 record.
SQL> update rse006dk set VG_9RSE006_PW_LAST_CHG_DATE=20100901 where VG_XRSE006_GROUP_ID='ITGRP6' and VG_XRSE006_USER_ID='NATALIE';

Below example are updating all record.
SQL> update rse006dk set VG_9RSE006_PW_LAST_CHG_DATE=20100901;

| 0 comments ]

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.