Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Tablespace?
- 5 Answers
- 9976 Views
- I also Faced
- E-Mail Answers
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 |
Is a rollback possible to any savepoint?
When can Hash Cluster used ?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What is a parameter file in oracle?
what is grid in Oracle 10g...
can a view be updated?
How to resolve name conflicts between variables and columns?
What is TNS File
What is the data type of dual table?
What are a collation and state the different types of collation sensitivity?
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
What is tns entry?
Oracle General 
