문서의 선택한 두 판 사이의 차이를 보여줍니다.
양쪽 이전 판 이전 판 다음 판 | 이전 판 마지막 판 양쪽 다음 판 | ||
dbms:oracle:admin:flashback [2015/06/20 16:30] starlits [HR 계정으로 접속] |
dbms:oracle:admin:flashback [2017/02/18 02:29] starlits [HR 계정 flashback version query] |
||
---|---|---|---|
줄 7: | 줄 7: | ||
- < | - < | ||
==== HR 계정 활성화 ==== | ==== HR 계정 활성화 ==== | ||
- | - < | + | - < |
- | - < | + | - < |
==== HR 계정으로 접속 ==== | ==== HR 계정으로 접속 ==== | ||
- | - < | + | - < |
- < | - < | ||
+ | |||
+ | ==== HR 계정으로 AS OF SCN ==== | ||
+ | - < | ||
- < | - < | ||
- | - < | + | - < |
+ | - < | ||
+ | - < | ||
+ | - < | ||
+ | - < | ||
+ | - | ||
+ | ==== HR 계정으로 AS OF TIMESTAMP ==== | ||
+ | - < | ||
+ | - < | ||
+ | - < | ||
+ | - < | ||
+ | - < | ||
+ | - < | ||
+ | - < | ||
+ | as of timestamp(to_timestamp(' | ||
+ | - < | ||
+ | as of timestamp(to_timestamp(' | ||
+ | - < | ||
+ | as of timestamp(to_timestamp(' | ||
+ | |||
+ | |||
+ | ==== HR 계정 flashback version query ==== | ||
+ | - < | ||
+ | SQL> create table emp as select * from scott.emp; | ||
+ | |||
+ | SQL> select to_char(sysdate,' | ||
+ | 2015-06-20 16:57:28 | ||
+ | |||
+ | SQL> update emp set comm=1234 where empno=7782; | ||
+ | SQL> commit; | ||
+ | |||
+ | SQL> update emp set comm=3456 where empno=7782; | ||
+ | SQL> rollback; | ||
+ | |||
+ | SQL> update emp set comm=5678 where empno=7782; | ||
+ | SQL> commit; | ||
+ | |||
+ | SQL> update emp set comm=7890 where empno=7782; | ||
+ | SQL> commit; | ||
+ | |||
+ | SQL> select to_char(sysdate,' | ||
+ | 2015-06-20 17:01:08 | ||
+ | |||
+ | SQL> | ||
+ | set lines 200 | ||
+ | column ename format a10 | ||
+ | column start_time format a20 | ||
+ | column end_time format a20 | ||
+ | |||
+ | SELECT empno, ename, sal, comm, deptno, | ||
+ | versions_xid AS XID, | ||
+ | versions_operation as operation, | ||
+ | versions_startscn AS START_SCN, | ||
+ | versions_starttime as start_time, | ||
+ | versions_endscn AS END_SCN, | ||
+ | versions_endtime as end_time | ||
+ | FROM emp VERSIONS BETWEEN TIMESTAMP | ||
+ | TO_TIMESTAMP(' | ||
+ | AND TO_TIMESTAMP(' | ||
+ | WHERE empno=7782 | ||
+ | order by versions_starttime nulls first; | ||
+ | |||
+ | </ |