{"id":11913,"date":"2023-10-03T18:16:25","date_gmt":"2023-10-03T17:16:25","guid":{"rendered":"https:\/\/roglacup.com\/klaus62\/?p=11913"},"modified":"2023-10-31T18:41:02","modified_gmt":"2023-10-31T17:41:02","slug":"private-temporary-tables","status":"publish","type":"post","link":"https:\/\/roglacup.com\/klaus62\/2023\/10\/03\/private-temporary-tables\/","title":{"rendered":"Private Temporary Tables"},"content":{"rendered":"\n<h6 class=\"wp-block-heading\">Private Temporary Tables in Oracle Database 18c<\/h6>\n\n\n\n<p>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.<\/p>\n\n\n\n<p>If you&#8217;ve come to Oracle from a different database engine, like SQL Server, you might be confused by Oracle&#8217;s idea of temporary tables. 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.<\/p>\n\n\n\n<p>Posted from: <a href=\"https:\/\/oracle-base.com\/articles\/18c\/private-temporary-tables-18c\">https:\/\/oracle-base.com\/articles\/18c\/private-temporary-tables-18c<\/a><\/p>\n\n\n\n<p>Which two statements are true about space-saving features in an Oracle Database? (Choose two.)<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>A.\u00a0Private Temporary Tables (PTTS) store metadata in memory only<\/strong><\/li>\n\n\n\n<li><strong>B.\u00a0An index created with the UNUSABLE attribute has no segment<\/strong><\/li>\n\n\n\n<li><strong>C.\u00a0If they exist for a session, Private Temporary Tables (PTTs) are always dropped at the next COMMIT OR ROLLBACK statement<\/strong><\/li>\n\n\n\n<li>D.&nbsp;An index that is altered to be UNUSABLE will retain its segment<\/li>\n\n\n\n<li>E.&nbsp;A table that is truncated will always have its segment removed<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Private Temporary Tables in Oracle Database 18c 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. If you&#8217;ve come to Oracle from a different database engine, like SQL Server, you might be confused by Oracle&#8217;s&hellip;&nbsp;<a href=\"https:\/\/roglacup.com\/klaus62\/2023\/10\/03\/private-temporary-tables\/\" class=\"\" rel=\"bookmark\">Read More &raquo;<span class=\"screen-reader-text\">Private Temporary Tables<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[1299],"tags":[1311],"class_list":["post-11913","post","type-post","status-publish","format-standard","hentry","category-1z0-082","tag-private-temporary-tables"],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11913","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/comments?post=11913"}],"version-history":[{"count":4,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11913\/revisions"}],"predecessor-version":[{"id":11918,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/posts\/11913\/revisions\/11918"}],"wp:attachment":[{"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/media?parent=11913"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/categories?post=11913"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/roglacup.com\/klaus62\/wp-json\/wp\/v2\/tags?post=11913"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}