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.
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.
