https://www.adminschool.net/wiki/ 2026-04-22T06:19:07+00:00 https://www.adminschool.net/wiki/ https://www.adminschool.net/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:admin:flashback:recyclebin&rev=1759498250&do=diff recycle bin * 동일한 테이블을 생성 삭제를 반복한다 create table c1 (id varchar2(10); drop table c1; create table c1 (id varchar2(10); drop table c1; create table c1 (id varchar2(10); drop table c1; create table c1 (id varchar2(10); drop table c1; create table c1 (id varchar2(10); drop table c1; text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:admin:flashback:table&rev=1759498250&do=diff FLASHBACK Table * 테이블 생성 create table fb_table (cdate date default sysdate); * 데이타 입력 insert into fb_table values (sysdate); -- sleep 1 insert into fb_table values (sysdate); -- sleep 2 insert into fb_table values (sysdate); commit; text/html 2025-10-03T13:30:50+00:00 Anonymous (anonymous@undisclosed.example.com) https://www.adminschool.net/wiki/doku.php?id=dbms:oracle:admin:flashback:transaction_backout&rev=1759498250&do=diff flashback transaction backout * 사전작업 alter database add supplemental log data; alter database add supplemental log data (primary key) columns; grant execute on dbms_flashback to hr; grant select any transaction to hr; * 스크립트 실행