Oracle Segments

What are the different types of segments in Oracle?

Questions by arunakumaris

Showing Answers 1 - 2 of 2 Answers

narendra05

  • Apr 16th, 2010
 

There are following types of segments in Oracle

1. Data segments stores the data
2. Index segment stores the index data
3. Rollback segment : Stores undo data information for data consistency.


  Was this answer useful?  Yes

hmounir

  • Apr 21st, 2010
 

Four types of segments are found in an Oracle database:
1- Data segment every table in the database resides in a single data segment.
2- Index segment each index is stored in its own index segment.
3- Temporary segment when a user's SQL statement needs disk space to complete an operation.
4- Rollback segment only exist in the SYSTEM tablespace.

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions