Interested to Buy Any Domain ? << Click Here >> for more details...
What is tablespace in oracle?
how can we create?
how is it manage?
.
.
.
Thnx 2 All in Advnc....:)
- 3 Answers
- 5208 Views
- I also Faced
- E-Mail Answers
Answer Posted / sabari shan
*tablespace is the logical structure of the database.it contains collection of segments. segment contains collection of extents. extent contain collection of oracle blocks.
*Segment: residing space of every object.whenever u create any object one segment will create in the name of object.when the segment created it have no of extents.as a dba we can configure the no of extents when we create the tablespace.
*Extent: Actual space allocation and deallocation will done here.once the extent get filled next extent will create by the oracle server.
*Block: its is basic unit of storage. Here only the actual data will be store.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are dml statements in oracle?
What are the uses of synonyms?
Explain mutating triggers.
What is user managed backup in Oracle?
What is recovery manager(rman) backup in Oracle?
Explain drop constraint oracle?
What are ddl statements in oracle?
What is the usage of analyze command in oracle?
How to convert character types to numeric types?
How to insert a record into a table?
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
What is an oracle table?
How to define a variable of a specific record type?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How to filter out duplications in the returning rows using oracle?
