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
- 5244 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 the attributes that are found in a cursor?
What is backup in Oracle?
What is the difference between translate and replace?
How to connect the oracle server as sysdba?
What is Redo Log Buffer in Oracle?
How to grant create session privilege to a user in oracle?
Explain an integrity constrains?
How to see the table columns used in an index?
What is the difference between $oracle_base and $oracle_home?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
How to invoke the data pump export utility?
What is oracle rownum?
How do I limit the number of rows returned by an oracle query after ordering?
How can I get column names from a table in oracle?
Is it possible to split the print reviewer into more than one region ?
