문서의 이전 판입니다!
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;
connect hr/oracle select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual; INSERT INTO hr.regions VALUES (5,'Pole'); COMMIT; UPDATE hr.regions SET region_name='Poles' WHERE region_id = 5; UPDATE hr.regions SET region_name='North and South Poles' WHERE region_id = 5; COMMIT; INSERT INTO hr.countries VALUES ('TT','Test Country',5); COMMIT; select to_char(sysdate,'YYYY-MM-DD HH24:MI:SS') from dual; connect / as sysdba ALTER SYSTEM ARCHIVE LOG CURRENT;