tablespace


Also found in: Wikipedia.

tablespace

(oracle, database, storage)
A logical unit of storage, used by an Oracle database, that is made up of one or more operating system files. Each table, index or other object that requires storage is located on a tablespace.

The database administrator typically assigns a default and a temporary tablespace to each user and grants a quota on each so they can create tables and indexes.
References in periodicals archive ?
What needs to be recovered: the full database, a tablespace, a single table, an index, or combinations thereof?
CREATE SNAPSHOT snapshop_name PCTFREE 0 PCTUSED 99 STORAGE (INITIAL 100K NEXT 100K PCTINCREASE 0) TABLESPACE SNAPS REFRESH [FAST | COMPLETE] START WITH start_date NEXT NEXT_DAY (TRUNC (start_date,'format')) +hour/24 WITH PRIMARY KEY AS SELECT.
the scheduling of statistics-gathering, the monitoring of database performance, the monitoring of tablespace usage, the expanding and reorganization of tablespaces, etc.
Brian will discuss logs and backup management, tablespace storage management, table value compression and maintenance, and new features in version 10 that help with storage management.
A 14-ARTIST EXHIBITION ABOUT FUNCTIONAL POTtery cannot hope to be comprehensive, yet Tablespace stretched far and wide, including one representative each from Denmark, Japan, Canada and Germany in addition to the American participants.
High-availability capabilities such as automatic block repair and tablespace point-in-time recovery aren't in, for one.
The second edition covers features new to Oracle database 11g release 2 and adds a section on tablespace encryption.
Disk I/O: One must make sure the tablespaces are laid out correctly so that we don't have one type of tablespace adversely affecting another.
Occupying a modest tablespace over in one of the Val Expo areas I found an Indian dealer new to me.
The Disk Health tab gives users an overview of the amount of hard disk space, tablespace and files being used.
Full or tablespace backup of a database while it is online or off-line
SharePack further improves application performance and availability by offering the replication component with built-in monitoring and diagnostics as well as application tuning with SQLab Vision, tablespace management and reorganization with Space Manager, and Schema Manager for change deployment -- all in all improving the integrity of the data being replicated.