Results 1 to 2 of 2

Thread: Ora-01555

  1. #1
    Join Date
    Mar 2004
    Location
    japan
    Posts
    35

    Red face Unanswered: Ora-01555

    Hi to all experts there,
    I facing the error when i run the report using report builder.
    My report run overnight.
    I refer 4 table to select the data , and i used BETWEEN TO_DATE
    (_frmdt, 'DD/MM/YYYY') AND TO_DATE(_todt, 'DD/MM/YYYY')
    to pass my date.
    but end up with error
    'ORA-01555 : snapshot too old : rollback segment number 58 with
    name "RB08" too small.

    Anybody can help me and explain to me why this kind of error come up.
    It cousing by what.

    Thanks in advance.

    regards,
    natalie

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Check this out

    http://www.ixora.com.au/tips/admin/ora-1555.htm

    If you are on 9i or above then you might want to check out undo tablespaces

    http://www.oracle.com/technology/ora...o45tuning.html

    .

Posting Permissions

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