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 would you do with an in-doubt distributed transaction?
Is insert autocommit in oracle?
What happens to the current transaction if the session is ended?
Explain database link?
what is the scripts in data base?
How to view the data files in the current database?
when i run my query on yesterday it is fast but today it is slow why?
Explain oracle’s server parameter file.
Explain the function of optimizer in oracle?
How to write date and time literals in oracle?
Why do you use stored procedures and state some of its disadvantages?
What is BBED in Oracle?