Discussion
1
Replies
93
Views
Posted: June 4, 2015
Last activity: April 6, 2018
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.
This is a DB error caused due to exceeded Maximum Open Cursors.
Increase Open_Cursors Value from 1000 to ~6000 to resolve the issue.