Privilege required for "as of timestamp" clause
969019Jan 28 2013 — edited Jan 28 2013When I try following SQL to retrieve records in some table XXXXX in the past point in time:
select * from XXXXX as of timestamp systimestamp-(6/24);
I am receiving following error:
ORA-01031: insufficient privileges
Without "as of timestamp" clause, it does run fine.
Which privilege do I have to receive for above to work?
Thank you in advance.