?UNDO????????
??????UNDO????????????
select tablespace_name,retention from dba_tablespaces where tablespace_name = 'UNDOTBS1'
?UNDO?????
alter tablespace 'UNDOTBS1' retention GUARANTEE;
?SCN??????????????
select current_scn,scn_to_timestamp(current_scn) from v$database
select timestamp_to_scn(systimestamp), systimestamp from dual
????????????
SCN??
select name from test as of scn 344387777 where id = 2
??????????????????
SCN??
select
versions_xid XID,
versions_startscn START_SCN,
versions_endscn END_SCN,
versions_operation OPERATION,
id,name
from test versions between scn minvalue and maxvalue
?????????????????????
SCN??
select * from flashbak_transaction_query where table_name='TEST'
?oracle flashbak query
update test set name= (select name from test as of scn 344387777 where id = 2) where id=2
?oracle flushbak table
?flashback table ?? or flashback any table ?? ???
?????????????
alter table test enable row movement
???????????
???????????NG
??????????????NG
?????????????????????
flashback table test to scn 344494686
?oracle flushbak drop
flashback table test to before drop rename to 'test2'
????????????????????????????????NG
??????????????????
--??????
select index_name from user_indexes where table_name='TEST';
--????
alter index "BINXXXXXXXXXXXXX" rename to pk_test;