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

vishu19aug · Post by **vishu19aug** » 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

jwiles · Post by **jwiles** » 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,

chulett · Post by **chulett** » 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.

vishu19aug · Post by **vishu19aug** » Tue Jun 19, 2012 10:28 am

Thanks! "jwiles" and "chulett"