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 join query for one source type is oracle another source type is sql server ?

1989


How to loop through data rows in the implicit cursor?

539


Explain cascading triggers.

574


What is a procedure in oracle?

618


What is oracle join syntax?

570






Explain user account with reference to oracle.

532


Explain self joins in oracle?

560


Which are the five query types available in oracle?

528


What is an oracle cursor variable?

607


material view and view disadvantages?

635


What is ordinary table in oracle?

652


How to change program global area (pga) in oracle?

584


List the types of joins used in writing subqueries?

573


What are the set operators union, union all, minus & intersect meant to do?

562


What is integrity and what is constraint??Explain with example

1699