dbms:oracle:admin:flashback:transaction_backout

차이

문서의 선택한 두 판 사이의 차이를 보여줍니다.

차이 보기로 링크

--- dbms:oracle:admin:flashback:transaction_backout [2016/05/08 06:20]
starlits
+++ dbms:oracle:admin:flashback:transaction_backout [2016/05/21 08:29]
starlits
@@ 줄 25: / 줄 25: @@
 connect / as sysdba
 ALTER SYSTEM ARCHIVE LOG CURRENT;
+</code>
+  - Query flashback_transaction_query to get the transaction id and the list of all transactional changes from the undo data <code>
+select xid, table_name, operation, undo_sql --,start_timestamp,commit_timestamp
+from flashback_transaction_query
+where table_name IN ('COUNTRIES','REGIONS');
 </code>

dbms/oracle/admin/flashback/transaction_backout.txt · 마지막으로 수정됨: 2016/05/21 08:32 저자 starlits