What is a Tablespace?

Answer Posted / javeed_mj

An Oracle database consists of one or more logical storage
units called tablespaces, which collectivley store all of
the database's data.

Each tablespace in an ORACLE database consists of one or
more files called datafiles, which are physical structures
that conform with the operating system in which Oracle is
running.

For Example::: A simple Oracle Database have one tablespace
and one datafile

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is null value in oracle?

621


What do you mean by a deadlock?

511


How to define an oracle cursor variable?

558


What is the usage of analyze command in oracle?

604


How to set a transaction to be read only in oracle?

573






Is it possible to insert comments into sql statements return in the data model editor ?

2061


What is not equal to in oracle?

518


Explain cascading triggers.

568


How to do clean up if create database failed?

566


What is difference between truncate and delete?

551


What is the sql query to concatenate column values from multiple rows in oracle?

553


what happened to the global index when I truncate the data in one of the partition?

1512


Is the After report trigger fired if the report execution fails ?

2396


Explain implicit cursor.

548


What is partitioned table in Oracle?

624