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 |
How do I uninstall oracle 11g?
after installatio of ORACLE 8i, work properly, but after restarting the system, it throw an error ORA 01034: ORACLE not availble
What is a Data Segment ?
what are the database links ?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
1.display list of all users from ur data base.what is the query?
What is the disadvantage of User defind function?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
Explain the dml?
After update how do u know how many records got updated
What are inner join and outer join?
select to_char('10','10') from dual This gives me an error oRA-1481 INVALID NUMBER FORMAT MODEL why? pls help