ORA-01000: Maximum open cursors exceeded

[CJ]

G'day folks,

When I try to reverse engineer our database (about 180 tables), I get the ORA-01000 repeatedly (I don't know how many times) ... I just hold down the enter key until the message box doesn't show up anymore, and the process seems to be done.

I talked with the DBA, and Oracle is set to allow up to 500 cursors per session.  Is there something I haven't setup correctly for the ODBC data source?  Or, is there some bug in EA?

Finally, if it is a bug in EA, does it have any negative impact on the reverse engineering process, other than repeating the ORA-01000 message over and over again?

Much appreciated and best regards.

[CJ]

G'day folks,

Got the DBA to double the max number of cursors per session to 1000, and no more problems.

Is there a guideline as to the max number of cursors per session required to reverse engineer a data model?  Is the number of cursors related somehow to the number of tables being imported?