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 are the sql clauses supported in the link property sheet ?
Explain a segment?
What happens in oracle commit?
How do I uninstall oracle client from windows?
What is Reduced List of Values?
Can objects of the same Schema reside in different tablespaces.?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
Explain alias?
What is the relationship among database, tablespace and data file?
what is the bitmap index?
How to enter a new row into a table interactively?
Briefly explain what is literal? Give an example where it can be used?