User Tools

Site Tools


kurs:flashback_table

select * from departments as of timestamp sysdate - 1/12

desc flashback_transaction_query

Flashback Data Archive

sql> create tablespace fla datafile '/u01/app/oracle/oradata/orcl/fla01.dbf' size 10m;

SQL> create flashback archive fla1 tablespace fla quota 10m retention 1000 year;

Flashback archive created.

SQL> grant flashback archive on fla1 to bla;

Grant succeeded.

als user
SQL> alter table blu flashback archive fla1;

DMLs
sql> commit;

SQL> select * from user_flashback_archive_tables;
SQL> select * from blu as of timestamp (systimestamp - ds_interval('0 00:02:00'));

Flashback Transaction Backout

SQL> startup mount
ORACLE instance started.
SQL> alter database archivelog;

Database altered.

SQL> alter database add supplemental log data;

Database altered.

SQL> alter database add supplemental log data (primary key) columns;

Database altered.
SQL> startup force
SQL> alter system archive log current;
SQL> alter system archive log current;

sql> dmls an der tabelle => commit

im em schema-> tables -> flashback transactions
kurs/flashback_table.txt · Last modified: 2014/09/10 21:22 (external edit)