1-- DESCRIPTION
2--  Simple example script to create  tablespaces
3-- usage:
4--   sqlplus "/ as sysdba" @create_ts.sql DATA_TOP
5
6SPOOL "create_ts.log"
7
8create tablespace DBMAIL_TS_DATA
9datafile '&1/dbmail_ts_data01.dbf'
10size 400M
11autoextend on
12next 100M maxsize 4000M
13extent management local
14uniform size 1M;
15
16create tablespace DBMAIL_TS_IDX
17datafile '&1/dbmail_ts_idx0i1.dbf'
18size 400M
19autoextend on
20next 100M maxsize 4000M
21extent management local
22uniform size 1M;
23
24SPOOL OFF
25EXIT;
26
27