BIGFILE TABLESPACE

posted Feb 3, 2012, 4:07 PM by Sachchida Ojha
Bigfile tablespace eases database administration because it consist of only one datafile. The single datafile can be up to 128TB in size if the tablespace block size is 32KB.

CREATE BIGFILE TABLESPACE bigtbs DATAFILE '/u01/oracle/data/bigftbs01.dbf' SIZE 50G

Bigfile tablespaces are supported only for locally managed tablespaces with automatic segment
space management, with three exceptions: locally managed undo tablespaces, temporary tablespaces,
and the SYSTEM tablespace.

Comments