{"id":3776,"date":"2018-04-18T09:39:24","date_gmt":"2018-04-18T00:39:24","guid":{"rendered":"http:\/\/haisins.epac.to\/wordpress\/?p=3776"},"modified":"2018-04-18T09:39:24","modified_gmt":"2018-04-18T00:39:24","slug":"oracle-12c-%eb%a9%80%ed%8b%b0%ed%85%8c%eb%84%8c%ed%8a%b8-%ed%99%98%ea%b2%bd%ec%97%90%ec%84%9c-flashback-transaction-query-%ec%a7%80%ec%9b%90-%eb%b6%88%ea%b0%80","status":"publish","type":"post","link":"http:\/\/haisins.synology.me\/wordpress\/?p=3776","title":{"rendered":"[Oracle 12c] \uba40\ud2f0\ud14c\ub10c\ud2b8 \ud658\uacbd\uc5d0\uc11c Flashback Transaction Query \uc9c0\uc6d0 \ubd88\uac00"},"content":{"rendered":"<p>\uba40\ud2f0 \ud14c\ub10c\ud2b8 \ucee8\ud14c\uc774\ub108 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\ub294 \uc774\ub7ec\ud55c Oracle Flashback \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. (CDB):<\/p>\n<p>&#8211;\u00a0\u00a0\u00a0 For Oracle Database 12c Release 1 (12.1.0.1), Flashback Data Archive (FDA) is not supported in a CDB.\u00a0 For Oracle Database 12c Release 1 (12.1.0.2), this restriction is removed.<\/p>\n<p>&#8211;\u00a0\u00a0\u00a0 Flashback Transaction Query is not supported in a CDB.<\/p>\n<p>&#8211;\u00a0\u00a0\u00a0 Flashback Transaction Backout is not supported in a CDB.<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<pre class=\"lang:plsql decode:true \">SQL&gt; conn system\/oracle@pdb2\r\n\r\nConnected.\r\n\r\nSQL&gt; select count(*) from flashback_transaction_query;\r\n\r\nselect count(*) from flashback_transaction_query\r\n\r\n                     *\r\n\r\nERROR at line 1:\r\n\r\nORA-01295: DB_ID mismatch between dictionary USE_ONLINE_CATALOG and logfiles<\/pre>\n<p>&nbsp;<\/p>\n<h3 id=\"READM-GUID-7D281CED-2CE6-4CB9-AC5E-A8ED8F064929\" class=\"sect3\">Features Not Available or Restricted for a Multitenant Container Database in Oracle Database 12<span class=\"italic\">c<\/span>\u00a0Release 2 (12.2)<\/h3>\n<div>\n<p>The following is a list of features that are not available or are restricted for a multitenant container database (CDB):<\/p>\n<ul>\n<li>Flashback Transaction Query (in both local undo mode and shared undo mode)<\/li>\n<li>Database Recovery Advisor<\/li>\n<li>Oracle Sharding<\/li>\n<\/ul>\n<\/div>\n<p>&nbsp;<\/p>\n<p>https:\/\/docs.oracle.com\/en\/database\/oracle\/oracle-database\/12.2\/readm\/features-not-available-12-2-beta.html#GUID-F3D717CD-13DA-408B-8FE8-43CABAD21B58<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\uba40\ud2f0 \ud14c\ub10c\ud2b8 \ucee8\ud14c\uc774\ub108 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0\ub294 \uc774\ub7ec\ud55c Oracle Flashback \uae30\ub2a5\uc744 \uc0ac\uc6a9\ud560 \uc218 \uc5c6\uc2b5\ub2c8\ub2e4. (CDB): &#8211;\u00a0\u00a0\u00a0 For Oracle Database 12c Release 1 (12.1.0.1), Flashback Data Archive (FDA) is not supported in a CDB.\u00a0 For Oracle Database 12c Release 1 (12.1.0.2), this restriction is removed. &#8211;\u00a0\u00a0\u00a0 Flashback Transaction Query is not supported in a CDB. &#8211;\u00a0\u00a0\u00a0 Flashback Transaction Backout [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":2069,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"spay_email":""},"categories":[20],"tags":[1081,710,1077,1079,1080,74,1078,1076,1075],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/haisins.synology.me\/wordpress\/wp-content\/uploads\/2018\/01\/oracle-database-upgrade-12c.jpg?fit=625%2C325","amp_enabled":true,"_links":{"self":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3776"}],"collection":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3776"}],"version-history":[{"count":1,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3776\/revisions"}],"predecessor-version":[{"id":3777,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/3776\/revisions\/3777"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=\/wp\/v2\/media\/2069"}],"wp:attachment":[{"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3776"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3776"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/haisins.synology.me\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3776"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}