$phinx19 wrote:post URL to Oracle documentation where "temporary tables" are discussed.
What is the purpose of Oracle temporary tables? Is it just for sorting purpose or there is something more to it? Is sorting good when it happens in the temporary table?
>In my opinion, the word "generally" he used implies that in some cases, a temporary table is not stored in a temporary tablespace. Or, probably, I haven't understood what he meant (and that was why I wanted him to share some light on this).
A temporary tablespace is also (generally) used to store the data that is in a temporary table.