All pastes #278901 Raw Edit

Unnamed

public text v1 · immutable
·published 2006-12-14 14:42 UTC
rendered paste body
#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;