What is a Temporary Segment ?

Answer Posted / bijender singh

Temporary segements are created during the sorting
operation in the temporary tablespace and released after
the execution.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is oracle analytical function?

523


What is the maximum limit on the number of columns in a table?

547


How to do paging with oracle?

568


What is the exact use of Collections?

1675


How to use in conditions in oracle?

547






How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?

2720


How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

543


Can sub procedure/function be called recursively?

530


What are the different windows events activated at runtime ?

2408


What is the data pump import utility?

577


What are the types of trigger in oracle?

571


Explain the features of oracle?

590


What is oracle open database communication (odbc)?

553


How to insert a new row into a table in oracle?

581


What are the restrictions in a oracle read only transaction?

562