ORA-01555 caused by SQL statement
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: ORA-01555 caused by SQL statement

  1. #1
    Join Date
    Sep 2006
    Posts
    19

    ORA-01555 caused by SQL statement

    hi we have a 10g (10.1.0.2.0) 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.)

    undo_retention=900
    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
    Location
    Mooresville, NC
    Posts
    349
    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.
    http://www.perf-engg.com
    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