Discussion Board

Temporary segment Oracle allocates space for segments in units of one extent. Temporary segment : Created when a SQL statement needs a temporary work area; these segments are destroyed when the SQL statement is finished. These segments are used during various database operations, such as sorts. Data segment : It stores user data within the database. Temp segment : There is a temporary tablespace called as temp which is used internally by the database for operations like distinct join etc. Prajakta Pandit 02-16-2017 10:41 PM

Write your comments

*

* Email must be in the form someone@domain.com

*

*