top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What is Table space in Oracle?

+2 votes
337 views
What is Table space in Oracle?
posted Apr 23, 2015 by Viswas Kumar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

A tablespace is a storage location where the actual data underlying database objects can be kept. It provides a layer of abstraction between physical and logical data, and serves to allocate storage for all DBMS managed segments.

or

A tablespace is a logical group of data files in a database. A database typically contains at least one tablespace, and usually two or more. Within the database, the tablespace plays a role similar to that of a folder on the hard drive of a computer.

The CREATE TABLESPACE statement is used to allocate space in the Oracle database where schema objects are stored.

The CREATE TABLESPACE statement can be used to create the 3 kinds of tablespaces:

  1. Permanent Tablespace

  2. Temporary Tablespace

  3. Undo Tablespace

answer Apr 23, 2015 by Shivaranjini
...