What are the different types of Segments?

<<Previous  Next>>

Oracle - What are the different types of Segments? - April 10, 2009 at 11:00 AM

What are the different types of Segments?  

Data Segment
Index Segment
Rollback Segment
and Temporary Segment.

Oracle - What are the different types of Segments? - June 20, 2009 at 15:00 PM

An Oracle database can use four types of segments:

Data segment--Stores user data within the database.
Index segment--Stores indexes.
Rollback segment--Stores rollback information used when data must be rolled back.
Temporary segment--Created when a SQL statement requires a temporary work area such as during sorting of data.

Also read

Oracle architecture

Describe Oracle architecture in brief, What is the function of SMON?, Explain different types of segment, Explain SGA memory structures..............

Oracle Backup and Recovery

What is configure command and recovery catalog?, What are different types of backup? (Hot, Cold, logical, Physical)?, Whats the Concept of Flashback Query in Oracle (10g in particular) and how is it beneficial?...............

Oracle clusters

A cluster contains data from one or more tables. All these tables have one or more columns in common. All the rows from all the tables that share the same cluster key............... .

<<Previous  Next>>

Write your comment - Share Knowledge and Experience