What is a Temporary Segment ?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Can a property clause itself be based on a property clause ?
what are the default admin accounts in Oracle 10g ?
How can we force the database to use the user specified rollback segment?
How to call a trigger inside a stored procedure?Give an example.
Iam learning oracle developer 2000.. can anyone give me then tutorials sites or PDF related to developer 2000 please send me the details @ mak2786@gmail.com thanks Arun
Explain the use of parfile option in exp command.
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
what is dynamic SGA and static SGA
How do I learn what codesets are available in oracle?
How to write an inner join with the where clause in oracle?
Explain how are indexes update?
How to assign data of the deleted row to variables?