Build Script

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

-- 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;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.