In Oracle, what is the difference between temp and permanent tables?
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 love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With