DSXchange

Posted: **Tue Jun 19, 2012 8:46 am**

Hi,

I am trying to import the table definition of 10 tables at a time and getting the following error -
The OCI function OCIStmtExecute returned status -1. Error code: 1,000, Error message: ORA-01000: maximum open cursors exceeded.

Can somebody help?

Thanks,
Vishal Gupta

Posted: **Tue Jun 19, 2012 8:56 am**

Ask your DBA if they can increase the OPEN_CURSORS value for the database, otherwise import fewer table definitions at one time.

Regards,

Posted: **Tue Jun 19, 2012 9:46 am**

Or perhaps do the import at a "less busy" time if you have a plethora of jobs running against that source right now.

Posted: **Tue Jun 19, 2012 10:28 am**

Thanks! "jwiles" and "chulett"

DSXchange

ORA-01000: maximum open cursors exceeded, impoting table def

ORA-01000: maximum open cursors exceeded, impoting table def

Thanks!