Ora-01555
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Ora-01555

Threaded View

  1. #1
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865

    Ora-01555

    One of my query got failed with 01555. But I didn't see any reasons for this because ...

    undo table space is 180G
    undo retention is 2 hours

    and the above said query which is running from ETL frame work has a target commit interval for every 100000 rows.

    Thou source and target tables are more than 150M each and the whole query SLA is 19 hours still i didn't see any reason to tail with 01555 because the above undo & commit settings.

    I have attached the query for your reference and the insert query is just a plain insert.

    Please note that, this is the ONLY session running in the database during 01555.

    Oracle 10.2.0.4
    OS: HP
    ETL: Informatica

    Thanks,
    Attached Files Attached Files
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

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