Hi,
On 11.2.0.4 on Oracle Linux:
I run the following bein logged on as sys dba
SQL> flashback table ATABLE to timestamp (SYSTIMESTAMP - INTERVAL '200' MINUTE);
flashback table ATABLE to timestamp (SYSTIMESTAMP - INTERVAL '200' MINUTE)
*
Error
ORA-08185:Flashback not supported for user SYS
Cause: user logged on as SYS
Action: logon as a different (non SYS) user.
SQL> grant select on ATABLE to LDAP_USER;
SQL> exit
SQL>connected
SQL> show user
USER is "LDAP_USER"
SQL> flashback table ATABLE to timestamp (SYSTIMESTAMP - INTERVAL '200' MINUTE);
flashback table ATABLE to timestamp (SYSTIMESTAMP - INTERVAL '200' MINUTE)
*
Error
ORA-08185:Flashback not supported for user SYS
Even if I'm loged on I receive the same error.
Thanks for help.