How to overcome ORA-0100 error during data upgrade DDL generation?

Discussion

Replies

Views

natan

Member since 2012

32 posts

PEGA

Posted: June 4, 2015

Last activity: April 6, 2018

Posted: 4 Jun 2015 9:27 EDT
Last activity: 6 Apr 2018 19:26 EDT

Closed

How to overcome ORA-0100 error during data upgrade DDL generation?

I got "ORA-0100: Maximum Open cursors exceeded" during the DDL generation of data upgrade. How can I get rid of this error?

**Moderation Team has archived post**

This post has been archived for educational purposes. Contents and links will no longer be updated. If you have the same/similar question, please write a new post.

System Administration

Updates

Moderation Team has archived post,

This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Discussion, please write a new Discussion.

Posted: 6 years ago

Posted: 5 Jun 2015 2:05 EDT

divam

PEGA

replied to natan

This is a DB error caused due to exceeded Maximum Open Cursors.

Increase Open_Cursors Value from 1000 to ~6000 to resolve the issue.

Discussion

How to overcome ORA-0100 error during data upgrade DDL generation?

Related content:

We'd prefer it if you saw us at our best.