Answer Posted / orawhiz
Temporary segments are created by ORACLE when a SQL statement
needs a temporary work area to complete execution. When the
statement finishes execution, the temporary segment extents are
released to the system for future use.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Explain what are the type of synonyms?
Explain temporal data types in oracle
What is the difference between PFILE and SPFILE in Oracle?
Can you have more than one content canvas view attached with a window ?
How to get the Installed Oracle Version Information ?
What are the limitations of check constraint?
What is a partition in oracle?
How to use subqueries with the exists operator in oracle?
How to speed up webrick?
What happens in oracle commit?
Is it possible to insert comments into sql statements return in the data model editor ?
How to use in conditions in oracle?
Explain index?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
How do I start tns listener?