eNVenta ERP Tablespaces erstellen

On 3. September 2012

Mit folgendem Script können die von eNVenta ERP benötigten Tablespaces inkl. Datendateien in einer laufenden Oracle Instanz erstellt werden:

CREATE TABLESPACE DATA1      
DATAFILE 'C:oracleappadminoradataDBNAMEdata1.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;
CREATE TABLESPACE DATA2     
DATAFILE 'C:oracleappadminoradataDBNAMEdata2.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;
CREATE TABLESPACE DATA3      
DATAFILE 'C:oracleappadminoradataDBNAMEdata3.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;
CREATE TABLESPACE DATA4      
DATAFILE 'C:oracleappadminoradataDBNAMEdata4.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;
CREATE TABLESPACE INDEX1      
DATAFILE 'C:oracleappadminoradataDBNAMEindex1.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;
ALTER TABLESPACE DATA1      
ADD DATAFILE 'C:oracleappadminoradataDBNAMEdata1_2.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;
ALTER TABLESPACE DATA1      
ADD DATAFILE 'C:oracleappadminoradataDBNAMEdata1_3.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;
ALTER TABLESPACE DATA1      
ADD DATAFILE 'C:oracleappadminoradataDBNAMEdata1_4.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;
ALTER TABLESPACE DATA2      
ADD DATAFILE 'C:oracleappadminoradataDBNAMEdata2_2.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;
ALTER TABLESPACE DATA3      
ADD DATAFILE 'C:oracleappadminoradataDBNAMEdata3_2.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;
ALTER TABLESPACE DATA4      
ADD DATAFILE 'C:oracleappadminoradataDBNAMEdata4_2.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;
ALTER TABLESPACE INDEX1      
ADD DATAFILE 'C:oracleappadminoradataDBNAMEindex1_2.dbf' SIZE 10M      
AUTOEXTEND ON NEXT 1000M  MAXSIZE 32767M;

Schreibe einen Kommentar