Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace question

Re: Tablespace question

From: Thomas Pall <tpall_at_bga.com>
Date: 12 Nov 98 22:28:22 GMT
Message-ID: <364b6106.0@feed1.realtime.net>


A tablespace is made up of one or more data files. It contains a header and blocks . The size of the blocks is specified at database creation in the initialization file initSID.ora with the parameter data_block_size.

A tablespace contains the extents of objects. An extent is a contiguous chunk of blocks which contain all or part of an object. The entire object is called a segment. Examples of segments are tables, clusters, indexes, temporary segments, rollback segments. The size of each extent is defined upon creation of the object in the storage clause of the create object (table, index, cluster) command. If storage is not specified, the object is created with the default storage specified during creation of the tablespace. If no storage was specified during creation of the tablespace, Oracle assigns a default number of data blocks to the storage of the object.

Tablespaces do not store a users (schemna) objects. If the user creating the object has a quota on a tablespace or unlimited tablespace system privilege, they can create the object in the tablespace they choose (with some exceptions). Compiled objects: views, functions, triggers, procedures, packages are all stored in the SYSTEM tablespace. Users are given a default tablespace when they are created. If they create and object and do not specify a tablespace for the object, the object goes into their default tablespace, assuming they have a quota on the tablespace or unlimited tablespace privilege.

Rajesh Bhave (rajeshb_at_india.hp.com) wrote:
: Hello

: Does tablespace contain schema object itself or associated segments of
: the created object. Oracle SQL manual mentions that tablespace contain
: objects. Let me know.

: Thanx,
: Rajesh

-- Received on Thu Nov 12 1998 - 16:28:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US