양쪽 이전 판
이전 판
다음 판
|
이전 판
다음 판
양쪽 다음 판
|
dbms:oracle:admin:flashback [2016/11/06 07:56] starlits [HR 계정 flashback version query] |
dbms:oracle:admin:flashback [2017/02/18 02:10] starlits [HR 계정 flashback version query] |
- <code> export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'</code> | - <code> export NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'</code> |
==== HR 계정 활성화 ==== | ==== 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 계정으로 접속 ==== | ==== HR 계정으로 접속 ==== |
- <code> sqlplus scott/oracle </code> | - <code> sqlplus hr/oracle </code> |
- <code> SQL> select systimestamp from dual; </code> | - <code> SQL> select systimestamp from dual; </code> |
| |
==== HR 계정으로 AS OF SCN ==== | ==== 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> 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> select count(*) from emp2; </code> |
- <code> SQL> delete from emp2; </code> | - <code> SQL> delete from emp2; </code> |
==== HR 계정 flashback version query ==== | ==== HR 계정 flashback version query ==== |
- <code> | - <code> |
| SQL> create table emp as select * from scott.emp; |
| |
SQL> select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual; | SQL> select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual; |
2015-06-20 16:57:28 | 2015-06-20 16:57:28 |