RM/Oracle - TableSpace 9i

Script de criação de Table Space - Oracle 9i


CREATE TABLESPACE RM_DADOS
DATAFILE 'C:\oracle\product\10.2.0\oradata\corporer\RMDADOS1.DAT' SIZE 120M AUTOEXTEND ON NEXT 10M
DEFAULT STORAGE ( INITIAL 8K
NEXT 256
MINEXTENTS 1
MAXEXTENTS 121
PCTINCREASE 50);

CREATE TABLESPACE RM_DADOS_FF
DATAFILE 'C:\oracle\product\10.2.0\oradata\corporer\RMDADOS2.DAT' SIZE 100M AUTOEXTEND ON NEXT 10M
DEFAULT STORAGE ( INITIAL 8K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS 121
PCTINCREASE 0);

CREATE TABLESPACE RM_INDICES
DATAFILE 'C:\oracle\product\10.2.0\oradata\corporer\RMIND1.IDX' SIZE 30M AUTOEXTEND ON NEXT 10M
DEFAULT STORAGE ( INITIAL 8K
NEXT 84K
MINEXTENTS 1
MAXEXTENTS 121
PCTINCREASE 50);

CREATE TEMPORARY TABLESPACE RM_TMP
TEMPFILE 'C:\oracle\product\10.2.0\oradata\corporer\RMTMP1.DAT' SIZE 10M AUTOEXTEND ON NEXT 5M
EXTENT MANAGEMENT LOCAL;