DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2006

    ORA-01555 caused by SQL statement

    hi we have a 10g ( db running on windows.user executed a qry to retrive the data from a table as of friday.

    SELECT * FROM table1 AS OF TIMESTAMP TO_TIMESTAMP('2007-11-30 10:00:12', 'YYYY-MM-DD HH24:MI:SS') where tno='0104'

    However he is getting snapshot too old error.. Actually we have shutdown the database on saturday for backup at 11.00am and again started at 16.00pm. We are able to see the data after 16.00pm(saturday.)

    db_flashback_retention_target 1440
    can any one tell us why we are not able to see friday's data.

  2. #2
    Join Date
    Nov 2002
    Mooresville, NC
    If you get ORA-01555 error that should explain you the stuff. This means your undo retention time is small which is causing the issue.
    A performance engineering forum

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.