In Oracle, what is the difference between temp and permanent tables?
+7
A:
The content of a temporary table in oracle is only visible for the current session or the current transaction.
Therefore they are perfect for temporary data. No worry that other users see (and get confused by) the data. No need to explicitly clean up after you.
Also, you don't generate REDO for a temporary table as it will never be used 9eg for restore). As such they can be faster
(if you upvote this answer please upvote gary's comment as well since I just copied it into the answer)
Jens Schauder
2010-01-13 22:46:44
Also, you don't generate REDO for a temporary table as it will never be used 9eg for restore). As such they can be faster.
Gary
2010-01-14 02:19:21
A:
For an overview of all Oracle table types, including temporary, see the Oracle Concepts Guide.
Tony Andrews
2010-01-14 11:10:01