Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 Oracle PL/SQL: Build Script Jump to:  
Category: >> Oracle PL/SQL >> Build Script Bookmark and Share

<< lastnext >>

Snippet Name: Build Script

Description: This is a sample build script for creating a database instance.

Comment: (none)

Language:
Highlight Mode: PLSQL
Last Modified: February 28th, 2009

-- This file must be run out of the directory containing the
-- initialization file.
 
--  Create Database Instance
 
CREATE DATABASE OPRD
   CONTROLFILE REUSE
       LOGFILE 'F:\ORAPROD\LOG\prod01.log' size 6M reuse,
               'F:\ORAPROD\LOG\prod02.log' size 6M reuse,
               'F:\ORAPROD\LOG\prod03.log' size 6M reuse,
               'F:\ORAPROD\LOG\prod04.log' size 6M reuse,
               'F:\ORAPROD\LOG\prod05.log' size 6M reuse,
               'F:\ORAPROD\LOG\prod06.log' size 6M reuse,
               'F:\ORAPROD\LOG\prod07.log' size 6M reuse,
               'F:\ORAPROD\LOG\prod08.log' size 6M reuse,
               'F:\ORAPROD\LOG\prod09.log' size 6M reuse,
               'F:\ORAPROD\LOG\prod10.log' size 6M reuse
  MAXDATAFILES 1000
  MAXINSTANCES 3
-- ARCHIVELOG
-- or
-- NOARCHIVELOG
 CHARACTER SET WE8ISO8859P1
      DATAFILE 'G:\ORAPROD\sys1ssp.dbf'
         SIZE 250M
         AUTOEXTEND ON
         NEXT 125M
         MAXSIZE 500M;
 
   CREATE ROLLBACK SEGMENT system_rsp
      TABLESPACE SYSTEM
      STORAGE (INITIAL 128K NEXT 128K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 256K);
   ALTER ROLLBACK SEGMENT system_rsp ONLINE;
 
-- Create ORACDIS Tablespaces
   -- create ORACDIS tablespace
   CREATE TABLESPACE oracdis_dsp
      DATAFILE 'G:\ORAPROD\cdis1dsp.dbf'
         SIZE 5000M
         REUSE 
         AUTOEXTEND ON
         NEXT 500M 
         MAXSIZE 10000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   -- create ORACDIS index space
   CREATE TABLESPACE oracdis_isp
      DATAFILE 'I:\ORAPROD\cdis1isp.dbf' 
         SIZE 3000M
         REUSE 
         AUTOEXTEND ON
         NEXT 500M 
         MAXSIZE 9000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   -- create ORACDIS temp space
   CREATE TABLESPACE oracdis_tsp
      DATAFILE 'F:\ORAPROD\cdis1tsp.dbf' 
         SIZE 500M 
         REUSE 
         AUTOEXTEND ON
         NEXT 250M
         MAXSIZE 1000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      TEMPORARY;
 
-- Create Vertex Table Spaces
   -- create VERTEX data space
   CREATE TABLESPACE vertex_dsp
      DATAFILE 'G:\ORAPROD\vrtx1dsp.dbf'
         SIZE 2500M
         REUSE 
         AUTOEXTEND ON
         NEXT 500M 
         MAXSIZE 5000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   -- create VERTEX index space
   CREATE TABLESPACE vertex_isp
      DATAFILE 'D:\ORAPROD\vrtx1isp.dbf' 
         SIZE 500M
         REUSE 
         AUTOEXTEND ON
         NEXT 100M 
         MAXSIZE 1000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   -- create VERTEX temp space
   CREATE TABLESPACE vertex_tsp
      DATAFILE 'F:\ORAPROD\vrtx1tsp.dbf' 
         SIZE 100M 
         REUSE 
         AUTOEXTEND ON
         NEXT 100M
         MAXSIZE 500M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      TEMPORARY;
 
-- Create SQL*Time Tablespaces (not created by DDS DDL)
 
   -- USER_DATA: Create user sets this as the default tablespace
   CREATE TABLESPACE user_dsp
      DATAFILE 'G:\ORAPROD\user1dsp.dbf'
         SIZE 100M
         REUSE
         AUTOEXTEND ON
         NEXT 100M 
         MAXSIZE 500M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE user_isp
      DATAFILE 'D:\ORAPROD\user1isp.dbf'
         SIZE 50M
         REUSE
         AUTOEXTEND ON
         NEXT 50M 
         MAXSIZE 2500M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE user_tsp
      DATAFILE 'F:\ORAPROD\user1tsp.dbf' 
         SIZE 250M 
         REUSE 
         AUTOEXTEND ON
         NEXT 250M
         MAXSIZE 1000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 0)
      ONLINE
      TEMPORARY;
 
   CREATE TABLESPACE user_rsp
      DATAFILE 'G:\ORAPROD\user1rsp.dbf'
         SIZE 1000M
         REUSE
         AUTOEXTEND ON 
         NEXT 500M
         MAXSIZE 3500M
      DEFAULT STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 10000 PCTINCREASE 0)
      ONLINE
      PERMANENT;
 
   -- create rollback segments for SQL*Time
   CREATE PUBLIC ROLLBACK SEGMENT rb1
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb2
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb3
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb4
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb5
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb6
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb7
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb8
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb9
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb10
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb11
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb12
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb13
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb14
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb15
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb16
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb17
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb18
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb19
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb20
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb21
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb22
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb23
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb24
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb25
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb26
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb27
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb28
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb29
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   CREATE PUBLIC ROLLBACK SEGMENT rb30
   TABLESPACE  user_rsp
   STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 OPTIMAL 512K);
 
   ALTER ROLLBACK SEGMENT rb1 ONLINE;
   ALTER ROLLBACK SEGMENT rb2 ONLINE;
   ALTER ROLLBACK SEGMENT rb3 ONLINE;
   ALTER ROLLBACK SEGMENT rb4 ONLINE;
   ALTER ROLLBACK SEGMENT rb5 ONLINE;
   ALTER ROLLBACK SEGMENT rb6 ONLINE;
   ALTER ROLLBACK SEGMENT rb7 ONLINE;
   ALTER ROLLBACK SEGMENT rb8 ONLINE;
   ALTER ROLLBACK SEGMENT rb9 ONLINE;
   ALTER ROLLBACK SEGMENT rb10 ONLINE;
   ALTER ROLLBACK SEGMENT rb11 ONLINE;
   ALTER ROLLBACK SEGMENT rb12 ONLINE;
   ALTER ROLLBACK SEGMENT rb13 ONLINE;
   ALTER ROLLBACK SEGMENT rb14 ONLINE;
   ALTER ROLLBACK SEGMENT rb15 ONLINE;
   ALTER ROLLBACK SEGMENT rb16 ONLINE;
   ALTER ROLLBACK SEGMENT rb17 ONLINE;
   ALTER ROLLBACK SEGMENT rb18 ONLINE;
   ALTER ROLLBACK SEGMENT rb19 ONLINE;
   ALTER ROLLBACK SEGMENT rb20 ONLINE;
   ALTER ROLLBACK SEGMENT rb21 ONLINE;
   ALTER ROLLBACK SEGMENT rb22 ONLINE;
   ALTER ROLLBACK SEGMENT rb23 ONLINE;
   ALTER ROLLBACK SEGMENT rb24 ONLINE;
   ALTER ROLLBACK SEGMENT rb25 ONLINE;
   ALTER ROLLBACK SEGMENT rb26 ONLINE;
   ALTER ROLLBACK SEGMENT rb27 ONLINE;
   ALTER ROLLBACK SEGMENT rb28 ONLINE;
   ALTER ROLLBACK SEGMENT rb29 ONLINE;
   ALTER ROLLBACK SEGMENT rb30 ONLINE;
 
   -- create rollback segment tablespace for batch jobs
   CREATE TABLESPACE vbig_rsp
      DATAFILE 'G:\ORAPROD\vbig1rsp.dbf'
         SIZE 500M
         REUSE
         AUTOEXTEND ON 
         NEXT 250M 
         MAXSIZE 2000M
      DEFAULT STORAGE (INITIAL 2M NEXT 2M MINEXTENTS 2 MAXEXTENTS 1000 PCTINCREASE 0)
      ONLINE
      PERMANENT;
 
   CREATE PUBLIC ROLLBACK SEGMENT jam
   TABLESPACE  vbig_rsp
   STORAGE (INITIAL 2M NEXT 2M MINEXTENTS 2 MAXEXTENTS 1000 OPTIMAL 4M);
 
   ALTER ROLLBACK SEGMENT jam ONLINE;
 
   -- create AXTELL tablespace
   CREATE TABLESPACE axtell_data
      DATAFILE 'G:\ORAPROD\AXDSP1.dbf'
         SIZE 700M
         REUSE 
         AUTOEXTEND ON
         NEXT 250M 
         MAXSIZE 1400M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   -- create AXTELL index space
   CREATE TABLESPACE axtell_index
      DATAFILE 'D:\ORAPROD\AXISP1.dbf' 
         SIZE 300M
         REUSE 
         AUTOEXTEND ON
         NEXT 100M 
         MAXSIZE 6000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   -- create AXTELL rollback space
   CREATE TABLESPACE axtell_rsp
      DATAFILE 'G:\ORAPROD\AXRSP1.dbf'
         SIZE 60M
         REUSE
         AUTOEXTEND ON 
         NEXT 60M 
         MAXSIZE 360M
      DEFAULT STORAGE (INITIAL 256K NEXT 256K MINEXTENTS 2 MAXEXTENTS 100 PCTINCREASE 0)
      ONLINE
      PERMANENT;
 
   -- create AXTELL rollback segment
   CREATE ROLLBACK SEGMENT axtell_rollback
   TABLESPACE axtell_rsp
   STORAGE (INITIAL 5M NEXT 5M MINEXTENTS 2 MAXEXTENTS 6 OPTIMAL 10M);
 
   ALTER PUBLIC ROLLBACK SEGMENT axtell_rollback ONLINE;
 
   -- create tools tablespace 
   CREATE TABLESPACE tools_dsp
      DATAFILE 'G:\ORAPROD\tool1dsp.dbf'
         SIZE 25M 
         REUSE
         AUTOEXTEND ON
         NEXT 25M 
         MAXSIZE 100M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   -- CREATE THE SQL*Time tablespaces
   CREATE TABLESPACE aeidat 
      DATAFILE 'G:\ORAPROD\aeid1dsp.dbf'
         SIZE 1000M 
         REUSE
         AUTOEXTEND ON
         NEXT 250M 
         MAXSIZE 2000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE aeiidx 
      DATAFILE 'D:\ORAPROD\aeid1isp.dbf'
         SIZE 10M
         REUSE
         AUTOEXTEND ON
         NEXT 10M 
         MAXSIZE 50M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE ctdat 
      DATAFILE 'G:\ORAPROD\ctdat1.dbf'
         SIZE 250M 
         REUSE
         AUTOEXTEND ON
         NEXT 250M 
         MAXSIZE 1000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE ctidx 
      DATAFILE 'D:\ORAPROD\ctidx1.dbf'
         SIZE 25M 
         REUSE
         AUTOEXTEND ON
         NEXT 25M 
         MAXSIZE 100M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE padat 
      DATAFILE 'G:\ORAPROD\padat1.dbf'
         SIZE 500M 
         REUSE
         AUTOEXTEND ON
         NEXT 250M 
         MAXSIZE 2000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE paidx 
      DATAFILE 'D:\ORAPROD\paidx1.dbf'
         SIZE 300M 
         REUSE
         AUTOEXTEND ON
         NEXT 100M 
         MAXSIZE 600M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE sddat 
      DATAFILE 'G:\ORAPROD\sddat1.dbf'
         SIZE 600M 
         REUSE
         AUTOEXTEND ON
         NEXT 200M 
         MAXSIZE 1200M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE sdidx 
      DATAFILE 'D:\ORAPROD\sdidx1.dbf'
         SIZE 150M 
         REUSE
         AUTOEXTEND ON
         NEXT 50M 
         MAXSIZE 300M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE sfdat 
      DATAFILE 'G:\ORAPROD\sfdat1.dbf'
         SIZE 1500M 
         REUSE
         AUTOEXTEND ON
         NEXT 500M 
         MAXSIZE 3000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE sfidx 
      DATAFILE 'D:\ORAPROD\sfidx1.dbf'
         SIZE 1000M 
         REUSE
         AUTOEXTEND ON
         NEXT 250M 
         MAXSIZE 2000M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE sydat 
      DATAFILE 'G:\ORAPROD\sydat1.dbf'
         SIZE 50M 
         REUSE
         AUTOEXTEND ON
         NEXT 50M 
         MAXSIZE 200M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   CREATE TABLESPACE syidx 
      DATAFILE 'D:\ORAPROD\syidx1.dbf'
         SIZE 25M
         REUSE
         AUTOEXTEND ON
         NEXT 25M 
         MAXSIZE 100M
      DEFAULT STORAGE (INITIAL 64K NEXT 64K MINEXTENTS 1 MAXEXTENTS 10000 PCTINCREASE 1)
      ONLINE
      PERMANENT;
 
   -- Take system rollback segment offline
   ALTER ROLLBACK SEGMENT system_rsp OFFLINE;
 
   ALTER USER SYSTEM DEFAULT TABLESPACE user_dsp;
   ALTER USER SYSTEM TEMPORARY TABLESPACE user_tsp;
 
   ALTER USER SYS IDENTIFIED BY AEISYS;
 
   -- create AEIDEV schema owner
   CREATE USER aeidev IDENTIFIED BY aeidev
     DEFAULT TABLESPACE user_dsp
     TEMPORARY TABLESPACE user_tsp
     QUOTA unlimited ON user_dsp;
   GRANT dba TO aeidev;
   GRANT ALTER ANY CLUSTER TO aeidev;
   GRANT ALTER ANY INDEX TO aeidev;
   GRANT ALTER ANY PROCEDURE TO aeidev;
   GRANT ALTER ANY SEQUENCE TO aeidev;
   GRANT ALTER ANY SNAPSHOT TO aeidev;
   GRANT ALTER ANY TABLE TO aeidev;
   GRANT ALTER ANY TRIGGER TO aeidev;
   GRANT ANALYZE ANY TO aeidev;
   GRANT AUDIT ANY TO aeidev;
   GRANT AUDIT SYSTEM TO aeidev;
   GRANT BACKUP ANY TABLE TO aeidev;
   GRANT COMMENT ANY TABLE TO aeidev;
   GRANT CREATE ANY CLUSTER TO aeidev;
   GRANT CREATE ANY INDEX TO aeidev;
   GRANT CREATE ANY PROCEDURE TO aeidev;
   GRANT CREATE ANY SEQUENCE TO aeidev;
   GRANT CREATE ANY SNAPSHOT TO aeidev;
   GRANT CREATE ANY SYNONYM TO aeidev;
   GRANT CREATE ANY TABLE TO aeidev;
   GRANT CREATE ANY TRIGGER TO aeidev;
   GRANT CREATE ANY VIEW TO aeidev;
   GRANT CREATE CLUSTER TO aeidev;
   GRANT CREATE PROCEDURE TO aeidev;
   GRANT CREATE PUBLIC SYNONYM TO aeidev;
   GRANT CREATE SEQUENCE TO aeidev;
   GRANT CREATE SNAPSHOT TO aeidev;
   GRANT CREATE SYNONYM TO aeidev;
   GRANT CREATE TABLE TO aeidev;
   GRANT CREATE TRIGGER TO aeidev;
   GRANT CREATE VIEW TO aeidev;
   GRANT DELETE ANY TABLE TO aeidev;
   GRANT DROP ANY CLUSTER TO aeidev;
   GRANT DROP ANY INDEX TO aeidev;
   GRANT DROP ANY PROCEDURE TO aeidev;
   GRANT DROP ANY SEQUENCE TO aeidev;
   GRANT DROP ANY SNAPSHOT TO aeidev;
   GRANT DROP ANY SYNONYM TO aeidev;
   GRANT DROP ANY TABLE TO aeidev;
   GRANT DROP ANY TRIGGER TO aeidev;
   GRANT DROP ANY VIEW TO aeidev;
   GRANT DROP PUBLIC SYNONYM TO aeidev;
   GRANT EXECUTE ANY PROCEDURE TO aeidev;
   GRANT FORCE ANY TRANSACTION TO aeidev;
   GRANT FORCE TRANSACTION TO aeidev;
   GRANT INSERT ANY TABLE TO aeidev;
   GRANT LOCK ANY TABLE TO aeidev;
   GRANT SELECT ANY SEQUENCE TO aeidev;
   GRANT SELECT ANY TABLE TO aeidev;
   GRANT UNLIMITED TABLESPACE TO aeidev;
   GRANT UPDATE ANY TABLE TO aeidev;
 
   -- create AEITEST schema owner
   CREATE USER aeitest IDENTIFIED BY aeitest
     DEFAULT TABLESPACE user_dsp
     TEMPORARY TABLESPACE user_tsp
     QUOTA unlimited ON user_dsp;
   GRANT dba TO aeitest;
   GRANT ALTER ANY CLUSTER TO aeitest;
   GRANT ALTER ANY INDEX TO aeitest;
   GRANT ALTER ANY PROCEDURE TO aeitest;
   GRANT ALTER ANY SEQUENCE TO aeitest;
   GRANT ALTER ANY SNAPSHOT TO aeitest;
   GRANT ALTER ANY TABLE TO aeitest;
   GRANT ALTER ANY TRIGGER TO aeitest;
   GRANT ANALYZE ANY TO aeitest;
   GRANT AUDIT ANY TO aeitest;
   GRANT AUDIT SYSTEM TO aeitest;
   GRANT BACKUP ANY TABLE TO aeitest;
   GRANT COMMENT ANY TABLE TO aeitest;
   GRANT CREATE ANY CLUSTER TO aeitest;
   GRANT CREATE ANY INDEX TO aeitest;
   GRANT CREATE ANY PROCEDURE TO aeitest;
   GRANT CREATE ANY SEQUENCE TO aeitest;
   GRANT CREATE ANY SNAPSHOT TO aeitest;
   GRANT CREATE ANY SYNONYM TO aeitest;
   GRANT CREATE ANY TABLE TO aeitest;
   GRANT CREATE ANY TRIGGER TO aeitest;
   GRANT CREATE ANY VIEW TO aeitest;
   GRANT CREATE CLUSTER TO aeitest;
   GRANT CREATE PROCEDURE TO aeitest;
   GRANT CREATE PUBLIC SYNONYM TO aeitest;
   GRANT CREATE SEQUENCE TO aeitest;
   GRANT CREATE SNAPSHOT TO aeitest;
   GRANT CREATE SYNONYM TO aeitest;
   GRANT CREATE TABLE TO aeitest;
   GRANT CREATE TRIGGER TO aeitest;
   GRANT CREATE VIEW TO aeitest;
   GRANT DELETE ANY TABLE TO aeitest;
   GRANT DROP ANY CLUSTER TO aeitest;
   GRANT DROP ANY INDEX TO aeitest;
   GRANT DROP ANY PROCEDURE TO aeitest;
   GRANT DROP ANY SEQUENCE TO aeitest;
   GRANT DROP ANY SNAPSHOT TO aeitest;
   GRANT DROP ANY SYNONYM TO aeitest;
   GRANT DROP ANY TABLE TO aeitest;
   GRANT DROP ANY TRIGGER TO aeitest;
   GRANT DROP ANY VIEW TO aeitest;
   GRANT DROP PUBLIC SYNONYM TO aeitest;
   GRANT EXECUTE ANY PROCEDURE TO aeitest;
   GRANT FORCE ANY TRANSACTION TO aeitest;
   GRANT FORCE TRANSACTION TO aeitest;
   GRANT INSERT ANY TABLE TO aeitest;
   GRANT LOCK ANY TABLE TO aeitest;
   GRANT SELECT ANY SEQUENCE TO aeitest;
   GRANT SELECT ANY TABLE TO aeitest;
   GRANT UNLIMITED TABLESPACE TO aeitest;
   GRANT UPDATE ANY TABLE TO aeitest;
 
   -- create AEIIS schema owner
   CREATE USER aeiis IDENTIFIED BY aeiis
     DEFAULT TABLESPACE aeidat
     TEMPORARY TABLESPACE user_tsp
     QUOTA unlimited ON aeidat;
   GRANT dba TO aeiis;
   GRANT ALTER ANY CLUSTER TO aeiis;
   GRANT ALTER ANY INDEX TO aeiis;
   GRANT ALTER ANY PROCEDURE TO aeiis;
   GRANT ALTER ANY SEQUENCE TO aeiis;
   GRANT ALTER ANY SNAPSHOT TO aeiis;
   GRANT ALTER ANY TABLE TO aeiis;
   GRANT ALTER ANY TRIGGER TO aeiis;
   GRANT ANALYZE ANY TO aeiis;
   GRANT AUDIT ANY TO aeiis;
   GRANT AUDIT SYSTEM TO aeiis;
   GRANT BACKUP ANY TABLE TO aeiis;
   GRANT COMMENT ANY TABLE TO aeiis;
   GRANT CREATE ANY CLUSTER TO aeiis;
   GRANT CREATE ANY INDEX TO aeiis;
   GRANT CREATE ANY PROCEDURE TO aeiis;
   GRANT CREATE ANY SEQUENCE TO aeiis;
   GRANT CREATE ANY SNAPSHOT TO aeiis;
   GRANT CREATE ANY SYNONYM TO aeiis;
   GRANT CREATE ANY TABLE TO aeiis;
   GRANT CREATE ANY TRIGGER TO aeiis;
   GRANT CREATE ANY VIEW TO aeiis;
   GRANT CREATE CLUSTER TO aeiis;
   GRANT CREATE PROCEDURE TO aeiis;
   GRANT CREATE PUBLIC SYNONYM TO aeiis;
   GRANT CREATE SEQUENCE TO aeiis;
   GRANT CREATE SNAPSHOT TO aeiis;
   GRANT CREATE SYNONYM TO aeiis;
   GRANT CREATE TABLE TO aeiis;
   GRANT CREATE TRIGGER TO aeiis;
   GRANT CREATE VIEW TO aeiis;
   GRANT DELETE ANY TABLE TO aeiis;
   GRANT DROP ANY CLUSTER TO aeiis;
   GRANT DROP ANY INDEX TO aeiis;
   GRANT DROP ANY PROCEDURE TO aeiis;
   GRANT DROP ANY SEQUENCE TO aeiis;
   GRANT DROP ANY SNAPSHOT TO aeiis;
   GRANT DROP ANY SYNONYM TO aeiis;
   GRANT DROP ANY TABLE TO aeiis;
   GRANT DROP ANY TRIGGER TO aeiis;
   GRANT DROP ANY VIEW TO aeiis;
   GRANT DROP PUBLIC SYNONYM TO aeiis;
   GRANT EXECUTE ANY PROCEDURE TO aeiis;
   GRANT FORCE ANY TRANSACTION TO aeiis;
   GRANT FORCE TRANSACTION TO aeiis;
   GRANT INSERT ANY TABLE TO aeiis;
   GRANT LOCK ANY TABLE TO aeiis;
   GRANT SELECT ANY SEQUENCE TO aeiis;
   GRANT SELECT ANY TABLE TO aeiis;
   GRANT UNLIMITED TABLESPACE TO aeiis;
   GRANT UPDATE ANY TABLE TO aeiis;
 
   -- create AEIMS schema owner
   CREATE USER aeims IDENTIFIED BY aeims
     DEFAULT TABLESPACE aeidat
     TEMPORARY TABLESPACE user_tsp
     QUOTA unlimited ON aeidat;
   GRANT dba TO aeiims;
   GRANT ALTER ANY CLUSTER TO aeiims;
   GRANT ALTER ANY INDEX TO aeiims;
   GRANT ALTER ANY PROCEDURE TO aeiims;
   GRANT ALTER ANY SEQUENCE TO aeiims;
   GRANT ALTER ANY SNAPSHOT TO aeiims;
   GRANT ALTER ANY TABLE TO aeiims;
   GRANT ALTER ANY TRIGGER TO aeiims;
   GRANT ANALYZE ANY TO aeiims;
   GRANT AUDIT ANY TO aeiims;
   GRANT AUDIT SYSTEM TO aeiims;
   GRANT BACKUP ANY TABLE TO aeiims;
   GRANT COMMENT ANY TABLE TO aeiims;
   GRANT CREATE ANY CLUSTER TO aeiims;
   GRANT CREATE ANY INDEX TO aeiims;
   GRANT CREATE ANY PROCEDURE TO aeiims;
   GRANT CREATE ANY SEQUENCE TO aeiims;
   GRANT CREATE ANY SNAPSHOT TO aeiims;
   GRANT CREATE ANY SYNONYM TO aeiims;
   GRANT CREATE ANY TABLE TO aeiims;
   GRANT CREATE ANY TRIGGER TO aeiims;
   GRANT CREATE ANY VIEW TO aeiims;
   GRANT CREATE CLUSTER TO aeiims;
   GRANT CREATE PROCEDURE TO aeiims;
   GRANT CREATE PUBLIC SYNONYM TO aeiims;
   GRANT CREATE SEQUENCE TO aeiims;
   GRANT CREATE SNAPSHOT TO aeiims;
   GRANT CREATE SYNONYM TO aeiims;
   GRANT CREATE TABLE TO aeiims;
   GRANT CREATE TRIGGER TO aeiims;
   GRANT CREATE VIEW TO aeiims;
   GRANT DELETE ANY TABLE TO aeiims;
   GRANT DROP ANY CLUSTER TO aeiims;
   GRANT DROP ANY INDEX TO aeiims;
   GRANT DROP ANY PROCEDURE TO aeiims;
   GRANT DROP ANY SEQUENCE TO aeiims;
   GRANT DROP ANY SNAPSHOT TO aeiims;
   GRANT DROP ANY SYNONYM TO aeiims;
   GRANT DROP ANY TABLE TO aeiims;
   GRANT DROP ANY TRIGGER TO aeiims;
   GRANT DROP ANY VIEW TO aeiims;
   GRANT DROP PUBLIC SYNONYM TO aeiims;
   GRANT EXECUTE ANY PROCEDURE TO aeiims;
   GRANT FORCE ANY TRANSACTION TO aeiims;
   GRANT FORCE TRANSACTION TO aeiims;
   GRANT INSERT ANY TABLE TO aeiims;
   GRANT LOCK ANY TABLE TO aeiims;
   GRANT SELECT ANY SEQUENCE TO aeiims;
   GRANT SELECT ANY TABLE TO aeiims;
   GRANT UNLIMITED TABLESPACE TO aeiims;
   GRANT UPDATE ANY TABLE TO aeiims;
 
   -- create AXTELL schema owner
   CREATE USER axtell IDENTIFIED BY axtell
     DEFAULT TABLESPACE axtell_data
     TEMPORARY TABLESPACE user_tsp
     QUOTA unlimited ON axtell_data;
   GRANT dba TO axtell;
   GRANT dba TO axtell;
   GRANT ALTER ANY CLUSTER TO axtell;
   GRANT ALTER ANY INDEX TO axtell;
   GRANT ALTER ANY PROCEDURE TO axtell;
   GRANT ALTER ANY SEQUENCE TO axtell;
   GRANT ALTER ANY SNAPSHOT TO axtell;
   GRANT ALTER ANY TABLE TO axtell;
   GRANT ALTER ANY TRIGGER TO axtell;
   GRANT ANALYZE ANY TO axtell;
   GRANT AUDIT ANY TO axtell;
   GRANT AUDIT SYSTEM TO axtell;
   GRANT BACKUP ANY TABLE TO axtell;
   GRANT COMMENT ANY TABLE TO axtell;
   GRANT CREATE ANY CLUSTER TO axtell;
   GRANT CREATE ANY INDEX TO axtell;
   GRANT CREATE ANY PROCEDURE TO axtell;
   GRANT CREATE ANY SEQUENCE TO axtell;
   GRANT CREATE ANY SNAPSHOT TO axtell;
   GRANT CREATE ANY SYNONYM TO axtell;
   GRANT CREATE ANY TABLE TO axtell;
   GRANT CREATE ANY TRIGGER TO axtell;
   GRANT CREATE ANY VIEW TO axtell;
   GRANT CREATE CLUSTER TO axtell;
   GRANT CREATE PROCEDURE TO axtell;
   GRANT CREATE PUBLIC SYNONYM TO axtell;
   GRANT CREATE SEQUENCE TO axtell;
   GRANT CREATE SNAPSHOT TO axtell;
   GRANT CREATE SYNONYM TO axtell;
   GRANT CREATE TABLE TO axtell;
   GRANT CREATE TRIGGER TO axtell;
   GRANT CREATE VIEW TO axtell;
   GRANT DELETE ANY TABLE TO axtell;
   GRANT DROP ANY CLUSTER TO axtell;
   GRANT DROP ANY INDEX TO axtell;
   GRANT DROP ANY PROCEDURE TO axtell;
   GRANT DROP ANY SEQUENCE TO axtell;
   GRANT DROP ANY SNAPSHOT TO axtell;
   GRANT DROP ANY SYNONYM TO axtell;
   GRANT DROP ANY TABLE TO axtell;
   GRANT DROP ANY TRIGGER TO axtell;
   GRANT DROP ANY VIEW TO axtell;
   GRANT DROP PUBLIC SYNONYM TO axtell;
   GRANT EXECUTE ANY PROCEDURE TO axtell;
   GRANT FORCE ANY TRANSACTION TO axtell;
   GRANT FORCE TRANSACTION TO axtell;
   GRANT INSERT ANY TABLE TO axtell;
   GRANT LOCK ANY TABLE TO axtell;
   GRANT SELECT ANY SEQUENCE TO axtell;
   GRANT SELECT ANY TABLE TO axtell;
   GRANT UNLIMITED TABLESPACE TO axtell;
   GRANT UPDATE ANY TABLE TO axtell;
 
   -- create ops$sqltime schema owner
   CREATE USER ops$sqltime IDENTIFIED BY start91
     DEFAULT TABLESPACE user_dsp_data
     TEMPORARY TABLESPACE user_tsp
     QUOTA unlimited ON user_dsp;
   GRANT dba TO ops$sqltime;
   GRANT ALTER ANY CLUSTER TO ops$sqltime;
   GRANT ALTER ANY INDEX TO ops$sqltime;
   GRANT ALTER ANY PROCEDURE TO ops$sqltime;
   GRANT ALTER ANY ROLE TO OPS$SQLTIME;
   GRANT ALTER ANY SEQUENCE TO ops$sqltime;
   GRANT ALTER ANY SNAPSHOT TO ops$sqltime;
   GRANT ALTER ANY TABLE TO ops$sqltime;
   GRANT ALTER ANY TRIGGER TO ops$sqltime;
   GRANT ANALYZE ANY TO ops$sqltime;
   GRANT AUDIT ANY TO ops$sqltime;
   GRANT AUDIT SYSTEM TO ops$sqltime;
   GRANT BACKUP ANY TABLE TO ops$sqltime;
   GRANT COMMENT ANY TABLE TO ops$sqltime;
   GRANT CREATE ANY CLUSTER TO ops$sqltime;
   GRANT CREATE ANY INDEX TO ops$sqltime;
   GRANT CREATE ANY PROCEDURE TO ops$sqltime;
   GRANT CREATE ROLE TO OPS$SQLTIME;
   GRANT CREATE ANY SEQUENCE TO ops$sqltime;
   GRANT CREATE ANY SNAPSHOT TO ops$sqltime;
   GRANT CREATE ANY SYNONYM TO ops$sqltime;
   GRANT CREATE ANY TABLE TO ops$sqltime;
   GRANT CREATE ANY TRIGGER TO ops$sqltime;
   GRANT CREATE ANY VIEW TO ops$sqltime;
   GRANT CREATE CLUSTER TO ops$sqltime;
   GRANT CREATE PROCEDURE TO ops$sqltime;
   GRANT CREATE PUBLIC SYNONYM TO ops$sqltime;
   GRANT CREATE SEQUENCE TO ops$sqltime;
   GRANT CREATE SNAPSHOT TO ops$sqltime;
   GRANT CREATE SYNONYM TO ops$sqltime;
   GRANT CREATE TABLE TO ops$sqltime;
   GRANT CREATE TRIGGER TO ops$sqltime;
   GRANT CREATE VIEW TO ops$sqltime;
   GRANT DELETE ANY TABLE TO ops$sqltime;
   GRANT DROP ANY CLUSTER TO ops$sqltime;
   GRANT DROP ANY INDEX TO ops$sqltime;
   GRANT DROP ANY PROCEDURE TO ops$sqltime;
   GRANT DROP ANY SEQUENCE TO ops$sqltime;
   GRANT DROP ANY SNAPSHOT TO ops$sqltime;
   GRANT DROP ANY SYNONYM TO ops$sqltime;
   GRANT DROP ANY TABLE TO ops$sqltime;
   GRANT DROP ANY TRIGGER TO ops$sqltime;
   GRANT DROP ANY VIEW TO ops$sqltime;
   GRANT DROP PUBLIC SYNONYM TO ops$sqltime;
   GRANT EXECUTE ANY PROCEDURE TO ops$sqltime;
   GRANT FORCE ANY TRANSACTION TO ops$sqltime;
   GRANT FORCE TRANSACTION TO ops$sqltime;
   GRANT INSERT ANY TABLE TO ops$sqltime;
   GRANT LOCK ANY TABLE TO ops$sqltime;
   GRANT SELECT ANY SEQUENCE TO ops$sqltime;
   GRANT SELECT ANY TABLE TO ops$sqltime;
   GRANT UNLIMITED TABLESPACE TO ops$sqltime;
   GRANT UPDATE ANY TABLE TO ops$sqltime;
 
   -- create oracdis schema owner
   CREATE USER oracdis IDENTIFIED BY oracdis
     DEFAULT TABLESPACE oracdis_dsp
     TEMPORARY TABLESPACE oracdis_tsp
     QUOTA unlimited ON oracdis_dsp;
   GRANT dba TO oracdis;
   GRANT ALTER ANY CLUSTER TO oracdis;
   GRANT ALTER ANY INDEX TO oracdis;
   GRANT ALTER ANY PROCEDURE TO oracdis;
   GRANT ALTER ANY SEQUENCE TO oracdis;
   GRANT ALTER ANY SNAPSHOT TO oracdis;
   GRANT ALTER ANY TABLE TO oracdis;
   GRANT ALTER ANY TRIGGER TO oracdis;
   GRANT ANALYZE ANY TO oracdis;
   GRANT AUDIT ANY TO oracdis;
   GRANT AUDIT SYSTEM TO oracdis;
   GRANT BACKUP ANY TABLE TO oracdis;
   GRANT COMMENT ANY TABLE TO oracdis;
   GRANT CREATE ANY CLUSTER TO oracdis;
   GRANT CREATE ANY INDEX TO oracdis;
   GRANT CREATE ANY PROCEDURE TO oracdis;
   GRANT CREATE ANY SEQUENCE TO oracdis;
   GRANT CREATE ANY SNAPSHOT TO oracdis;
   GRANT CREATE ANY SYNONYM TO oracdis;
   GRANT CREATE ANY TABLE TO oracdis;
   GRANT CREATE ANY TRIGGER TO oracdis;
   GRANT CREATE ANY VIEW TO oracdis;
   GRANT CREATE CLUSTER TO oracdis;
   GRANT CREATE PROCEDURE TO oracdis;
   GRANT CREATE PUBLIC SYNONYM TO oracdis;
   GRANT CREATE SEQUENCE TO oracdis;
   GRANT CREATE SNAPSHOT TO oracdis;
   GRANT CREATE SYNONYM TO oracdis;
   GRANT CREATE TABLE TO oracdis;
   GRANT CREATE TRIGGER TO oracdis;
   GRANT CREATE VIEW TO oracdis;
   GRANT DELETE ANY TABLE TO oracdis;
   GRANT DROP ANY CLUSTER TO oracdis;
   GRANT DROP ANY INDEX TO oracdis;
   GRANT DROP ANY PROCEDURE TO oracdis;
   GRANT DROP ANY SEQUENCE TO oracdis;
   GRANT DROP ANY SNAPSHOT TO oracdis;
   GRANT DROP ANY SYNONYM TO oracdis;
   GRANT DROP ANY TABLE TO oracdis;
   GRANT DROP ANY TRIGGER TO oracdis;
   GRANT DROP ANY VIEW TO oracdis;
   GRANT DROP PUBLIC SYNONYM TO oracdis;
   GRANT EXECUTE ANY PROCEDURE TO oracdis;
   GRANT FORCE ANY TRANSACTION TO oracdis;
   GRANT FORCE TRANSACTION TO oracdis;
   GRANT INSERT ANY TABLE TO oracdis;
   GRANT LOCK ANY TABLE TO oracdis;
   GRANT SELECT ANY SEQUENCE TO oracdis;
   GRANT SELECT ANY TABLE TO oracdis;
   GRANT UNLIMITED TABLESPACE TO oracdis;
   GRANT UPDATE ANY TABLE TO oracdis;
 
   GRANT CONNECT TO PUBLIC;
 


Free
Oracle Magazine
Subscriptions
and Oracle White Papers


SQL University.net courses meet the most demanding needs of the business world for advanced education in a cost-effective manner. SQL University.net courses are available immediately for IT professionals and can be taken without disruption of your workplace schedule or processes.

Compared to traditional travel-based training, SQL University.net saves time and valuable corporate resources, allowing companies to do more with less. That's our mission, and that's what we deliver.

Click here to find out more
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 203 users online    © 2009 psoug.org

PSOUG LOGIN
Username: 
Password: 
Forgot your password?