RM/Oracle - TableSpace 8i

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

CREATE TABLESPACE RM_DADOS
DATAFILE 'D:\ORANT\DATABASE\RMDADOS1.DAT' SIZE 120M AUTOEXTEND ON NEXT 10M
DEFAULT STORAGE ( INITIAL 8K
NEXT 256K
MINEXTENTS 1
MAXEXTENTS 121
PCTINCREASE 50);

CREATE TABLESPACE RM_DADOS_FF
DATAFILE 'D:\ORANT\DATABASE\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 'D:\ORANT\DATABASE\RMIND1.IDX' SIZE 30M AUTOEXTEND ON NEXT 10M
DEFAULT STORAGE ( INITIAL 8K
NEXT 84K
MINEXTENTS 1
MAXEXTENTS 121
PCTINCREASE 50);


CREATE TABLESPACE RM_TMP
DATAFILE 'D:\ORANT\DATABASE\RMTMP1.DAT' SIZE 10M AUTOEXTEND ON NEXT 5M
DEFAULT STORAGE ( INITIAL 8K
NEXT 42K
MINEXTENTS 1
MAXEXTENTS 121
PCTINCREASE 50)
TEMPORARY;