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

Thread: Ora-01555

Threaded View

  1. #1
    Join Date
    Mar 2006
    Charlotte, NC


    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.

    OS: HP
    ETL: Informatica

    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

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