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

How to find out what oracle odbc drivers are installed?

578


How can we view last record added to a table?

601


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1651


What is a nvl function? How can it be used?

562


What is java oracle used for?

526






Write a syntax for update query in oracle?

622


How to create a new table in your schema?

607


What is the difference between online and offline backups?

561


What is the difference between truncate & delete command?

617


Explain how are indexes update?

623


What is the recommended interval at which to run statspack snapshots, and why?

2437


What is an oracle user role?

569


How to pass a cursor variable to a procedure?

562


How to create a new view in oracle?

622


Explain a private synonyms?

634