Resize BIGFILE tablespaces directly using ALTER TABLESPACE


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

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles