Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

oracle - Temp table vs. Permanent table

In Oracle, what is the difference between temp and permanent tables?

like image 764
user250297 Avatar asked Jan 22 '26 01:01

user250297


1 Answers

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.

like image 100
Jens Schauder Avatar answered Jan 23 '26 15:01

Jens Schauder



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!