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 |
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
If I have a select statment which retrives 2 rows, & that rows have the same data in all the fields except the last field and I want to merge the 2 rows to be in 1 row with concatenating the last field which have the different data.... eg: the 1st row has these fields: A-B-C the second row has: A-B-X ........ i want to merge the two row to be in one row like ----> A- B- C,X
Briefly explain what is literal? Give an example where it can be used?
What do you mean by cdb and pdb in oracle 12c?
Anyone have the Latest Oracle Dumbs?While u have please forard to narain1411@gmail.com
Explain the difference between a procedure and a function? What do you understand by those terms?
which language is used to develop the oracle........?
What is oracle host variable?
What are the differences between char and varchar2 in oracle?
How would you optimize a slow SQL query?
Is primary key = unique key,not null? If yes,please explain IF No,please explain