Database Utilities (MOSC)

MOSC Banner

Flashback archive query error ora-01555

in Database Utilities (MOSC) 16 commentsAnswered ✓

I'm using Oracle database 18c. I created an FDA with a retention period of 365 days and I associated a table with this FDA:

  • When I query the table using "versions between timestamp minvalue and maxvalue", I only get the updates done today.
  • If I replace "minvalue" with an actual timestamp, I get all the results correctly.
  • If the timestamp is older than a certain date, I get error ora-01555. I couldn't know what is the actual minimum date. Last week it was about a month but today it is only 5 days.
  • Today I found that there is nothing in the history! All history data for last week is purged!
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center