Test Data Manager

Tech Tip: ORA-01000: maximum open cursors exceeded

  • 1.  Tech Tip: ORA-01000: maximum open cursors exceeded

    Posted 11-30-2017 08:22 AM

    This document can also be viewed at https://support.ca.com/us/knowledge-base-articles.TEC1612886.html 
    To see more documents like this, check out our TDM knowledge base here: CA Test Data Manager 

    Issue:

    While generating scripts with Subset, I am receiving the following error message- ORA-01000: maximum open cursors exceeded. 

    Environment:
    CA Test Data Manager (TDM)- Subset
    Cause:

    The ORA-01000: maximum open cursors exceeded error will occur when an Oracle database runs out of open cursors.  A cursor is a pointer to a private SQL area that stores information about the processing of a SELECT or data manipulation language (DML) statement (INSERT, UPDATE, DELETE, or MERGE). Cursor management of DML statements is handled by the Oracle Database.

    Resolution:

    To resolve this issue you will need to increase the number of open cursors available on your Oracle database.  Please discuss this with your DBA and they will be able to do this for you. The below Oracle knowledge documents will guide you through the process of increasing your cursors. 

    Additional Information:

    If you face any issues or have any questions about the steps, please open a support case by going to https://support.ca.com/us.html