Tablespace Management
Oracle tablespaces are the basic “logical” containers where users place all database objects that require or consume disk space. For example, basic tables and indexes consume disk space, so they must reside within a tablespace. Other database objects such as directories and external tables don’t consume space, so they merely require an entry in the data dictionary. For those objects that consume space, a key database management task is to make sure that sufficient room exists for both today’s and tomorrow’s needs. You want to avoid Oracle error messages such as “cannot allocate extent.” Thus tablespace and data file management are key, routine administrative tasks.
Because Toad originally began as a developer’s tool and ...
Get Toad for Oracle Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
