#1 (From website) SQL> CREATE TABLESPACE statspack DATAFILE '/u01/oracle/db/AKI1_statspack.dbf' SIZE 200M REUSE EXTENT MANAGEMENT LOCAL UNIFORM SIZE 512K SEGMENT SPACE MANAGEMENT AUTO PERMANENT ONLINE; #2 (Adapted from psoug) CREATE TABLESPACE statspack DATAFILE '/u01/oradata/CCDBS/statspack.dbf' SIZE 200M REUSE AUTOEXTEND OFF BLOCKSIZE 8192 FORCE LOGGING DEFAULT NOCOMPRESS EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K FLASHBACK ON ONLINE;