What is a Tablespace?
Answers were Sorted based on User's Feedback
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 |
Answer / chaudhry
A database is divided into Logical Storage Unit called
tablespaces. A tablespace is used to grouped related logical
structures together
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / aslam baig
javeed_mj answer is write, a database devided into two
parts logically tablespace and physically datafiles.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / nishi
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.
Is This Answer Correct ? | 0 Yes | 0 No |
What is a nvl function? How can it be used?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What are the types of trigger in oracle?
What is difference between UNIQUE constraint and PRIMARY KEY constraint ?
How many types of tables supported by oracle?
How to write a query with an inner join in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Give the Types of modules in a form?
What are the attributes of cursor?
what are the mandortary parameters required for cuncurrent program definition in oracle apps R12?
How to do paging with oracle?
What are the numeric comparison operations?