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.
This article is provided by FOLDOC - Free Online Dictionary of Computing (foldoc.org)
References in periodicals archive ?
The USERS tablespace in the root and all pluggable containers are encrypted, as well as any newly created tablespaces.
Box 1 CREATE USER PAUL IDENTIFIED BY PAUL DEFAULT TABLESPACE SYSTEM TEMPORARY TABLESPACE TEMP; Then, in a second step, we proceed by animating the specification via the ProB tool.
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......................................; In addition, we need to set the automatically refresh mechanism using 2 parameters stored into INIT.ORA file: JOB_QUEUE_PROCESSES which will take at least the value 1 (default value is 0) and JOB_QUEUE_INTERVAL which will take a value lower or equal with the value of the refresh time slot (default value is 60 seconds).
Database Storage Administration (Tablespace management, growth management, etc.) 4.
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