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