-- Création des tablespaces pour Designer  6i 4.3
prompt Creation des tablespaces pour Designer 6i r4.3 ...

CREATE TABLESPACE D_CONSTANT_GROW_INDEXES
 datafile '/u04/oradata/es22/constant_grow_indexes_01.dbf' size 10M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_CONSTANT_GROW_TABLES
 datafile '/u06/oradata/es22/constant_grow_tables_01.dbf' size 10M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_DEPENDENCY_INDEXES
 datafile '/u04/oradata/es22/dependency_indexes_01.dbf' size 10M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_DEPENDENCY_TABLES
 datafile '/u06/oradata/es22/dependency_tables_01.dbf' size 10M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_DIAGRAM_INDEXES
 datafile '/u04/oradata/es22/diagram_indexes_01.dbf' size 80M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_DIAGRAM_TABLES
 datafile '/u06/oradata/es22/diagram_tables_01.dbf' size 80M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_LOB_DATA
 datafile '/u06/oradata/es22/lob_data_01.dbf' size 5M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_RAPID_GROW_INDEXES
 datafile '/u04/oradata/es22/rapid_grow_indexes_01.dbf' size 130M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_RAPID_GROW_TABLES
 datafile '/u06/oradata/es22/rapid_grow_tables_01.dbf' size 130M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_SYSTEM_META_INDEXES
 datafile '/u04/oradata/es22/system_meta_indexes_01.dbf' size 20M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_SYSTEM_META_TABLES
 datafile '/u06/oradata/es22/system_meta_tables_01.dbf' size 20M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_TEMPORARY_INDEXES
 datafile '/u04/oradata/es22/temporary_indexes_01.dbf' size 25M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_TEMPORARY_TABLES
 datafile '/u06/oradata/es22/temporary_tables_01.dbf' size 10M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_VERSION_INDEXES
 datafile '/u04/oradata/es22/version_indexes_01.dbf' size 25M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;

CREATE TABLESPACE D_VERSION_TABLES
 datafile '/u06/oradata/es22/version_tables_01.dbf' size 15M
 EXTENT MANAGEMENT LOCAL AUTOALLOCATE;