Resize BIGFILE tablespaces directly using ALTER TABLESPACE

January 11, 2007

Oracle 10g introduced a new type of tablespace called BIGFILE. Unlike traditional tablespaces that are composed of up to 1,022 datafiles, a BIGFILE tablespace stores its data in a single datafile with a much larger capacity. BIGFILE tablespaces can grow as large as 32-128 terabytes (TB), depending on the chosen block size.

The article continues at http://builder.com.com/5100-6388_14-6148682.html?tag=sc