dbms:oracle:admin:flashback

차이

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

차이 보기로 링크

--- dbms:oracle:admin:flashback [2016/11/06 07:56]
starlits [HR 계정 flashback version query]
+++ dbms:oracle:admin:flashback [2017/02/18 02:29] (현재)
starlits [HR 계정 flashback version query]
@@ 줄 7: / 줄 7: @@
   - <code> export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'</code>
 ==== HR 계정 활성화 ====
-  - <code> SQL> alter user scott identified by oracle account unlock; </code>
+  - <code> SQL> alter user hr identified by oracle account unlock; </code>
-  - <code> SQL> grant execute on dbms_flashback to scott; </code>
+  - <code> SQL> grant execute on dbms_flashback to hr; </code>
 ==== HR 계정으로 접속 ====
-  - <code> sqlplus scott/oracle </code>
+  - <code> sqlplus hr/oracle </code>
   - <code> SQL> select systimestamp from dual; </code>
 ==== HR 계정으로 AS OF SCN ====
-  - <code> SQL> select dbms_flashback.get_system_change_number() from dual; </code>
   - <code> SQL> create table emp2 as select * from emp; </code>
+  - <code> SQL> select dbms_flashback.get_system_change_number() from dual; </code>
   - <code> SQL> select count(*) from emp2; </code>
   - <code> SQL> delete from emp2; </code>
@@ 줄 39: / 줄 39: @@
 ==== HR 계정 flashback version query ====
   - <code>
+SQL> create table emp as select * from scott.emp;
 SQL> select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual;
 -06-20 16:57:28
@@ 줄 71: / 줄 73: @@
     versions_endtime as end_time
 FROM emp VERSIONS BETWEEN TIMESTAMP
-        TO_TIMESTAMP('2015-06-20 16:57:28','YYYY-MM-DD HH24:MI:SS')
+        TO_TIMESTAMP('2015-06-20 16:57:27','YYYY-MM-DD HH24:MI:SS')
-   AND TO_TIMESTAMP('2015-06-20 17:01:08','YYYY-MM-DD HH24:MI:SS')
+   AND TO_TIMESTAMP('2015-06-20 17:01:09','YYYY-MM-DD HH24:MI:SS')
-WHERE empno=7782;
+WHERE empno=7782
+order by versions_starttime nulls first;
 </code>

dbms/oracle/admin/flashback.1478386577.txt.gz · 마지막으로 수정됨: 2016/11/06 07:56 저자 starlits