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
- 5064 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
IS it possible to built the oracle database without setting the kernal parameters?
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
What is a cognitive schema?
What are the differences between char and varchar2 in oracle?
How to update values on multiple rows in oracle?
What is the difference between translate and replace in oracle?
Explain view?
What are the different types of partitions in oracle?
How to empty your oracle recycle bin?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
can anyody please send me the dump for Oracle 10g certifications for DBA path?
Explain what are the characteristics of data files?
What are the different oracle database objects?
How to see free space of each tablespace?
how the indexes are stored in the Oracle Database?
