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 |
How do I recompile a procedure in oracle?
how to retrieve data from different tables ,place this data in different excel worksheets.
What happens to the data files if a tablespace is dropped?
What is Parallel Server ?
Can a field be used in a report without it appearing in any data group ?
Is it possible to enter only time value into a column of a table in sql?
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
How to remove a row in a database table?
How to use values from other tables in update statements using oracle?
A VIEWS takes memory in the database. If yes, how can u proove it? is there any way to display the size of views?
How to delete multiple rows from a table in oracle?
How to select oracle sequence from different schema and How to select oracle sequence from different Databases. Explain with example