Community

Resize BIGFILE tablespaces directly using ALTER TABLESPACE

(Bob Watkins) 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

Read More - Register for Free Membership

Tags: