What is table space?

I want to know the answer

Showing Answers 1 - 17 of 17 Answers

yasir

  • Oct 13th, 2005
 

Tablespace is an logical storage structure at the highest level that stores all the data in datafiles.

  Was this answer useful?  Yes

krishanu bardhan

  • Oct 22nd, 2005
 

Table-space is a physical concept.it has pages where the records of the database is stored with a logical perception of tables.so tablespace contains tables.

  Was this answer useful?  Yes

shashi

  • Oct 25th, 2005
 

Data Base is divided into 2 or more logical structure known as table space. Each table space one or  more physical data file in the hard disk. 

  Was this answer useful?  Yes

Prasath

  • Oct 26th, 2005
 

A table space is a storage structure containing tables, indexes and large objects

  Was this answer useful?  Yes

sarala

  • Oct 27th, 2005
 

A logical portion of a database used in allocating storage for table data and table indexes.

A tablespace is a logical structure that contains segments. Rollback, data, and index are the three types of segments created inside a tablespace. Each segment is made up of extents, and the extents are comprised of data blocks.

The system tablespace contains the data dictionary for the Oracle database.

  Was this answer useful?  Yes

Dhayanand darshanala

  • Nov 3rd, 2005
 

Oracle internally creates some space to store all the tables. This is referred as " Table Space ".

  Was this answer useful?  Yes

shuaib

  • Nov 11th, 2005
 

In oracle data is stored in datafiles its contain the table space its logically to store the data in table space.there are system tablespace user tablespace to stored the user data ,undo table space  for undo and temporary table space for the index.

  Was this answer useful?  Yes

shivkumar

  • Apr 12th, 2006
 

Collection of Blocks is called Extents

Collection of Extents is called Segments

And

Collection of Segments is called Table spaces.

  Was this answer useful?  Yes

A tablespace is an area of disk, comprised of one or more disk files. It can contain tables, indexes or clusters. One or more tablespaces make up a database. It can get full as records are added to tables, but a DBA can expand the tablespace by adding files or extending the datafiles.

  Was this answer useful?  Yes

pujavipin

  • Jun 9th, 2009
 

Table space is the logical storage area on which different users would have quota to create and maintain their objects and data.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions