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
- 5375 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 is the oracle implicit cursor?
What is a trigger and what are its types?
What are the restrictions on external table columns?
What is Trigger in Oracle?
What are the attributes of the cursor?
what is insert all statement in sql
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Explain the use of compress option in exp command.
What is a server parameter file in oracle?
How to see the table columns used in an index?
How to store pictures on to the database?
How do I find my oracle client driver version?
What is an index associated with a constraint?
What happens if you lost a data file?
What is the minimum client footprint required to connect c# to an oracle database?
