Database Installation Guide 25
D Appendix: Tablespace Creation Scripts
-------------------------------------------------------------------------
------------
--- Script: create_rdw_tablespaces.sql
--- Execute as: sysdba
--- Note: Before running this script:
--- Modify <datafile_path> values.
--- Modify datafile storage parameters and sizes based
on partitioning strategy.
-------------------------------------------------------------------------
---------
spool create_rdw_tablespaces.log
CREATE TABLESPACE cache_data
DATAFILE '<datafile_path>/cache_data01.dbf' SIZE 15M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
;
CREATE TABLESPACE dm_dim_data
DATAFILE '<datafile_path>/dm_dim_data01.dbf' SIZE 400M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
;
CREATE TABLESPACE dm_dim_index
DATAFILE '<datafile_path>/dm_dim_index01.dbf' SIZE 300M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
;
CREATE TABLESPACE dm_fact_data
DATAFILE '<datafile_path>/dm_fact_data01.dbf' SIZE 300M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
;
CREATE TABLESPACE dm_fact_index
DATAFILE '<datafile_path>/dm_fact_index01.dbf' SIZE 300M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
;
CREATE TABLESPACE dim_mtx_data
DATAFILE '<datafile_path>/dim_mtx_data01.dbf' SIZE 300M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
;
CREATE TABLESPACE dim_mtx_index
DATAFILE '<datafile_path>/dim_mtx_index01.dbf' SIZE 300M
AUTOEXTEND ON NEXT 100M MAXSIZE 2000M
EXTENT MANAGEMENT LOCAL
SEGMENT SPACE MANAGEMENT AUTO
;
CREATE TABLESPACE ms_meta_data
DATAFILE '<datafile_path>/ms_meta_data01.dbf' SIZE 300M