Hi,
Using oracle 11.2.0.3 had following sql
create table <table_name> nologging
tablespace mis_data
as
select *
from retailer_trn_report_type rt
minus
select *
from retailer_trn_report_type as of timestamp systimestamp - interval '4' hour
table concerned 300 rows added 12 rows to it.
when tried above got snapshot too old message. was able to comprae as had backup before did insert but curious dba mentioned got alert message
: EM Event: Warning:IKW - Snapshot Too Old Error detected: SQL ID cf4z1f0v9t12f, Snapshot SCN 0x0036.90d69b46, Recent SCN 0x0036.92433b72, Undo Tablespace UNDOTBS1, Current Undo Retention 2,082.
Why is this when table so small - is it due to with flashback query.
Thanks