Unix Administrator with Vertias Cluster Server The Computer Merchant, Ltd US-IL-Joliet Post A Job | Post A Resume

Tablespaces

Adding a datafile

alter tablespace user_data
add datafile 'e:\{sid}\data\usr2.dbf' size 30M;

alter tablespace user_data autoextend off;

Next and Maxsize are set to zero.

alter tablespace user_data
add datafile 'e:\{sid}\data\usr2.dbf';

alter tablespace user_data autoextend on max_size=40M;

Sets the maximum disk space allowed for automatic extension of the datafile.

alter tablespace user_data online;

alter tablespace user_data offline;

alter tablespace user_data begin backup;

alter tablespace user_data end backup;

This option does not prevent user from performing transactions.

alter tablespace user_data coalesce;

Coalesing gathers free segments. SMON usual cleans up free space.

Back to the LSS "How To" Series Main Page