{"id":55849,"date":"2024-02-18T17:12:28","date_gmt":"2024-02-18T17:12:28","guid":{"rendered":"https:\/\/dbtut.com\/?p=55849"},"modified":"2024-02-18T17:16:35","modified_gmt":"2024-02-18T17:16:35","slug":"flashback-transaction-in-oracle","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/","title":{"rendered":"Flashback Transaction In Oracle"},"content":{"rendered":"<p>In today&#8217;s article, we will learn important information and process steps about Flashback Transaction in Oracle Database.<\/p>\n<p>There are some prerequisites to use Flashback Transaction:<\/p>\n<p>The database must be in archive mode,<br \/>\nSupplemental logging must be active.<\/p>\n<p>Flashback transaction uses LOGMINER in the background, so anything that is not supported by LogMiner is not supported by Flashback Transaction.<\/p>\n<p>Data types that Flashback Transaction does not support:<\/p>\n<p>BFILE,<br \/>\nBLOB,<br \/>\nCLOB,<br \/>\nNCLOB,<br \/>\nXML<\/p>\n<p>Recovery with Flashback Transaction is done with the TRANSACTION_BACKOUT procedure of the DBMS_FLASHBACK api package.<\/p>\n<p>Parameters of this procedure;<\/p>\n<p><strong>NUMTXNS (Number Of Transaction) &#8211;<\/strong> Number of transactions to be recovered.<\/p>\n<p><strong>XIDS (Transaction List) &#8211;<\/strong> Transaction ID numbers to recover.<\/p>\n<p><strong>Back-Out Options &#8211;<\/strong> Used to specify dependent processes.<br \/>\nCASCADE &#8211; Used with transactions on which all transactions are dependent.<br \/>\nNOCASCADE &#8211; Used in operations that do not have dependencies. It is the default value.<br \/>\nNOCASCADE FORCE &#8211; The transaction is recovered regardless of dependent transactions.<br \/>\nNONCONFLICT ONLY &#8211; Recovers non-conflicting lines.<br \/>\nTIME &amp; SCN Hint &#8211; Used to enable the LogMiner tool to find the desired transactions easily. If left as default, the UNDO_RETENTION parameter is considered the starting point.<\/p>\n<p>Flashback Transaction process steps.<\/p>\n<p>1. First, database checks should be done.<\/p>\n<p>Is the database in archive mode?<\/p>\n<pre class=\"lang:default decode:true \">\t\tSQL&gt; select log_mode from v$database;\r\n\t\t\r\n\t\tLOG_MODE\r\n\t\t------------\r\nARCHIVELOG<\/pre>\n<p>Is Supplemental Logging active?<\/p>\n<pre class=\"lang:default decode:true \">\t\tSQL&gt; select SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_FK from v$database;\r\n\t\t\r\n\t\tSUPPLEME SUP SUP\r\n\t\t-------- --- ---\r\n\t\tYES      YES YES\r\n<\/pre>\n<p>2. Let&#8217;s create two tables with Foreign Key connections.<\/p>\n<pre class=\"lang:default decode:true \">\tSQL&gt; create table PERSONEL(\r\n\t  2  id number(2),\r\n\t  3  name varchar2(20),\r\n\t  4  f_day date,\r\n\t  5  city number(2))\r\n\t  6  tablespace DENEME;\r\n\t\r\n\tTable created.\r\n\t\r\n\tSQL&gt; create table CITY(\r\n\t  2  id number(2),\r\n\t  3  city varchar2(20))\r\n\t  4  tablespace DENEME;\r\n\t\r\n\tTable created.\r\n\t\r\n\tSQL&gt; alter table PERSONEL add constraint pk_pers primary key (id)  using index tablespace INDEX_TBS;\r\n\t\r\n\tTable altered.\r\n\t\r\n\tSQL&gt; alter table CITY add constraint pk_city primary key (id) using index tablespace INDEX_TBS;\r\n\t\r\n\tTable altered.\r\n\t\r\n\tSQL&gt; alter table PERSONEL add constraint fk_pers foreign key(city) references city (id);\r\n\t\r\nTable altered.<\/pre>\n<p>3. Let&#8217;s insert the data.<\/p>\n<pre class=\"lang:default decode:true \">\tSQL&gt; insert into city values (39, 'Kirklareli');\r\n\t\r\n\t1 row created.\r\n\t\r\n\tSQL&gt; insert into city values (2, 'Adiyaman');\r\n\t\r\n\t1 row created.\r\n\t\r\n\tSQL&gt; insert into PERSONEL values (1,'Emrah',sysdate,39);\r\n\t\r\n\t1 row created.\r\n\t\r\n\tSQL&gt; insert into PERSONEL values (2, 'Melih', sysdate, 2);\r\n\t\r\n\t1 row created.\r\n\t\r\n\tSQL&gt; insert into PERSONEL values (3, 'Ozan', sysdate, 2);\r\n\t\r\n1 row created.<\/pre>\n<p>4. Let&#8217;s learn the SCN number.<\/p>\n<pre class=\"lang:default decode:true \">\tSQL&gt; select dbms_flashback.get_system_change_number beging_SCN from dual;\r\n\t\r\n\tBEGING_SCN\r\n\t----------\r\n   2116288<\/pre>\n<p>5. Now let&#8217;s delete our connected data.<\/p>\n<pre class=\"lang:default decode:true \">\tSQL&gt; delete personel where city=2;\r\n\t\r\n\t2 rows deleted.\r\n\t\r\n\tSQL&gt; delete city where id=2;\r\n\t\r\n\t1 row deleted.<\/pre>\n<p>6. Let&#8217;s learn our SCN number again.<\/p>\n<pre class=\"lang:default decode:true \">\tSQL&gt; select dbms_flashback.get_system_change_number beging_SCN from dual;\r\n\t\r\n\tBEGING_SCN\r\n\t----------\r\n   2116993<\/pre>\n<p>7. Now, let&#8217;s find out the transaction ID number with the Flashback Transaction Query feature using the SCN number.<\/p>\n<pre class=\"lang:default decode:true \">\tSQL&gt; select distinct xid, start_scn, start_timestamp\r\n\tfrom flashback_transaction_query\r\n\twhere table_name='CITY'\r\n\tand\r\n\tstart_scn&gt;2116288 and commit_scn &lt; 2118412;\r\n\t\r\n\tXID               START_SCN START_TIM\r\n\t---------------- ---------- ---------\r\n\t07000C007E050000    2118365 23-SEP-14\r\n<\/pre>\n<p>8. Now let&#8217;s save all the dependent variables with the CASCADE option.<\/p>\n<pre class=\"lang:default decode:true \">\tSQL&gt; declare\r\n\tv_xid_arr sys.xid_array;\r\n\tbegin\r\n\tv_xid_arr := sys.xid_array('07000C007E050000');\r\n\tdbms_flashback.transaction_backout (\r\n\tnumtxns =&gt; 1,\r\n\txids=&gt; v_xid_arr,\r\n\toptions=&gt; dbms_flashback.cascade,\r\n\tscnhint=&gt;2116288\r\n\t);\r\n\tend;\r\n\t\/\r\n<\/pre>\n<p>9. We confirm &#8220;After&#8221;. You should not forget to &#8220;Commit&#8221;.<\/p>\n<pre class=\"lang:default decode:true \">\tSQL&gt; commit;\r\n<\/pre>\n<p>10. We see that data comes to our table.<\/p>\n<p>11. When the recovery process is successful, we can find out by querying the DBA_FLASHBACK_TXN_STATE image.<\/p>\n<pre class=\"lang:default decode:true \">\tSQL&gt; select * from DBA_FLASHBACK_TXN_STATE where xid=HEXTORAW('07000C007E050000');\r\n<\/pre>\n<p>12. Operations taken to recover can be seen by querying the dba_FLASHBACK_TXN_REPORT image.<\/p>\n<pre class=\"lang:default decode:true\">\tSQL&gt; select * from dba_FLASHBACK_TXN_REPORT;\r\n<\/pre>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_55849\" class=\"pvc_stats all  \" data-element-id=\"55849\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In today&#8217;s article, we will learn important information and process steps about Flashback Transaction in Oracle Database. There are some prerequisites to use Flashback Transaction: The database must be in archive mode, Supplemental logging must be active. Flashback transaction uses LOGMINER in the background, so anything that is not supported by LogMiner is not supported &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_55849\" class=\"pvc_stats all  \" data-element-id=\"55849\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":484,"featured_media":55850,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-55849","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-oracle"],"aioseo_notices":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Flashback Transaction In Oracle - Database Tutorials<\/title>\n<meta name=\"description\" content=\"In today&#039;s article, we will learn important information and process steps about Flashback Transaction in Oracle Database.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Flashback Transaction In Oracle - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"In today&#039;s article, we will learn important information and process steps about Flashback Transaction in Oracle Database.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2024-02-18T17:12:28+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-02-18T17:16:35+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-18-201017.png\" \/>\n\t<meta property=\"og:image:width\" content=\"704\" \/>\n\t<meta property=\"og:image:height\" content=\"271\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Onur ARDAHANLI\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Onur ARDAHANLI\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/\"},\"author\":{\"name\":\"Onur ARDAHANLI\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\"},\"headline\":\"Flashback Transaction In Oracle\",\"datePublished\":\"2024-02-18T17:12:28+00:00\",\"dateModified\":\"2024-02-18T17:16:35+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/\"},\"wordCount\":325,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-18-201017.png\",\"articleSection\":[\"ORACLE\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/\",\"name\":\"Flashback Transaction In Oracle - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-18-201017.png\",\"datePublished\":\"2024-02-18T17:12:28+00:00\",\"dateModified\":\"2024-02-18T17:16:35+00:00\",\"description\":\"In today's article, we will learn important information and process steps about Flashback Transaction in Oracle Database.\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-18-201017.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-18-201017.png\",\"width\":704,\"height\":271},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Flashback Transaction In Oracle\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6\",\"name\":\"Onur ARDAHANLI\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g\",\"caption\":\"Onur ARDAHANLI\"},\"url\":\"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Flashback Transaction In Oracle - Database Tutorials","description":"In today's article, we will learn important information and process steps about Flashback Transaction in Oracle Database.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/","og_locale":"en_US","og_type":"article","og_title":"Flashback Transaction In Oracle - Database Tutorials","og_description":"In today's article, we will learn important information and process steps about Flashback Transaction in Oracle Database.","og_url":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/","og_site_name":"Database Tutorials","article_published_time":"2024-02-18T17:12:28+00:00","article_modified_time":"2024-02-18T17:16:35+00:00","og_image":[{"width":704,"height":271,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-18-201017.png","type":"image\/png"}],"author":"Onur ARDAHANLI","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Onur ARDAHANLI","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/"},"author":{"name":"Onur ARDAHANLI","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6"},"headline":"Flashback Transaction In Oracle","datePublished":"2024-02-18T17:12:28+00:00","dateModified":"2024-02-18T17:16:35+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/"},"wordCount":325,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-18-201017.png","articleSection":["ORACLE"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/","url":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/","name":"Flashback Transaction In Oracle - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-18-201017.png","datePublished":"2024-02-18T17:12:28+00:00","dateModified":"2024-02-18T17:16:35+00:00","description":"In today's article, we will learn important information and process steps about Flashback Transaction in Oracle Database.","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-18-201017.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2024\/02\/Ekran-goruntusu-2024-02-18-201017.png","width":704,"height":271},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2024\/02\/18\/flashback-transaction-in-oracle\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"Flashback Transaction In Oracle"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/7fcd466cd0d347ec64aaa48f18f780c6","name":"Onur ARDAHANLI","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ecd20c3e1374ced4e1aefc82101cce4cd437be8fd957d1be3d106668b8a1b990?s=96&d=mm&r=g","caption":"Onur ARDAHANLI"},"url":"https:\/\/dbtut.com\/index.php\/author\/onurardahanli\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55849","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/484"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=55849"}],"version-history":[{"count":1,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55849\/revisions"}],"predecessor-version":[{"id":55851,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/55849\/revisions\/55851"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/55850"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=55849"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=55849"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=55849"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}