STEPS ----------------------- The issue can be reproduced at will with the following steps:
1) connect system/oracle
create user extsape_dba identified by oracle; grant connect,resource to extsape_dba; create table extsape_dba.t (t number); alter table extsape_dba.t enable row movement; select current_scn from v$database; insert into extsape_dba.t values (1); create user a identified by a; grant connect to a; grant select, insert, update,delete, flashback on extsape_dba.t to a;
flashback table extsape_dba.t to scn 6077362;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!