Private Temporary Tables

From Robs_Wiki
Revision as of 13:58, 13 February 2020 by Qadmin wiki (talk | contribs) (Created page with "__TOC__ == Introduction == Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped at the end of the session or transac...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Contents

Introduction

Oracle 18c introduced the concept of a private temporary table, a memory-based temporary table that is dropped at the end of the session or transaction depending on the setup. In SQL Server developers will regularly create a temporary table to do some work and drop it. In Oracle a Global Temporary Table (GTT) is a permanent metadata object that holds rows in temporary segments on a transaction-specfic or session-specific basis. It is not considered normal to create and drop GTTs on the fly. With the introduction of private temporary tables, Oracle has an option similar to that seen in other engines, where the table object itself is temporary, not just the data.