Thursday, February 10, 2011

oracle - Temp table vs. Permanent table

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 upvote this answer please upvote gary's comment as well since I just copied it into the answer)

    Gary : 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.
  • For an overview of all Oracle table types, including temporary, see the Oracle Concepts Guide.

    Ben Fulton : The link is dead
    Tony Andrews : Thanks, fixed it.

0 comments:

Post a Comment