Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Tablespace?
- 5 Answers
- 9967 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 |
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
what are different types of locks?
How to create a new user account in oracle?
Can multiple cursors being opened at the same time?
What is different types of joins?
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
What is a table index?
Is it possible to disable the parameter from while running the report ?
Is oracle a relational database?
What is a server parameter file in oracle?
What do you mean by merge in oracle?
What is an oracle recycle bin?
Oracle General 
