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 literal?

589


Explain drop constraint oracle?

589


How do I spool in oracle?

541


How to find the duplicate rows count from employees table in oracle?

550


what are steps for interface? where is exchange rate defined in which table?

1497






What is logical backup in oracle?

576


Explain the use of show option in imp command.

638


How do I learn what codesets are available in oracle?

574


What is recovery manager in Oracle?

589


Explain a segment?

619


Explain view?

577


What is difference between truncate and delete?

561


What are the benefits of ordbms?

619


What is define in oracle?

565


How to create an initialization parameter file?

535