Resize BIGFILE tablespaces directly using ALTER TABLESPACE

[From Builder.com]

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

Get the Free Newsletter!

Subscribe to Cloud Insider for top news, trends & analysis

Latest Articles