Interested to Buy Any Domain ? << Click Here >> for more details...
What is a Tablespace?
- 5 Answers
- 9726 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 |
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
What is a Database instance ? Explain?
write a query to count number of alphabets in given string for example "APPLE" write a query to generate sequence from 50 to 100 write a query to display in single string "ABCD,EFGH,IJKL,PQRS"
Explain what are the characteristics of data files?
Explain what are clusters?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command ?
What is PL/SQL ?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
how to we delete a row using varray
What happens if the update subquery returns multiple rows?
if i have a procedure with 1000 line.when i run this in 61 line i got the error but i want to continue the programe without error.can anyone tell me how to handle that error.
Oracle General 
