SQL - What is table space?

GeekInterview.com > Interview Questions > Database > SQL

Go To First | Previous Question | Next Question

SQL | Question 40 of 139

What is table space?

i want to know the answer

Total Answers and Comments: 11

Last Update: August 07, 2009 Asked by: vinod

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

Sorting Options

Page 1 of 2

« First

Last »

October 13, 2005 15:51:57

yasir

RE: what is table space

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

Is this answer useful? Yes | No

October 22, 2005 09:49:36

krishanu bardhan

RE: what is table space

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.

Is this answer useful? Yes | No

October 25, 2005 02:23:51

shashi

RE: what is table space

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.

Is this answer useful? Yes | No

October 26, 2005 06:50:53

Prasath

RE: what is table space

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

Is this answer useful? Yes | No

October 27, 2005 13:41:57

sarala

RE: what is table space

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.

Is this answer useful? Yes | No

November 03, 2005 23:24:34

Dhayanand darshanala

RE: what is table space

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

Is this answer useful? Yes | No

November 11, 2005 02:06:07

shuaib

RE: what is table space

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.

Is this answer useful? Yes | No

April 12, 2006 04:16:35

shivkumar

RE: what is table space

Collection of Blocks is called Extents

Collection of Extents is called Segments

And

Collection of Segments is called Table spaces.

Is this answer useful? Yes | No

January 03, 2009 20:24:33

venkatesh ambale

Member Since: December 2008 Contribution: 1

RE: What is table space?

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.

Is this answer useful? Yes | No

June 09, 2009 01:56:03

#10

pujavipin

Member Since: June 2009 Contribution: 4

RE: What is table space?

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

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top

User Name		Remember Me?
Password

Question Bank