Re: limitation of CURSORs

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Tue, 03 Aug 1999 08:21:55 -0400
Message-ID: <37A6DEE3.3BA3F742@Unforgettable.com>

You need to increase the 'open_cursors' parameter in your initxxx.ora file and bounce the database.

Ken

Nandakumar wrote:

> When i try to drop a view, i get an error that says maximum CURSOR limit
> has exceeded.
>
> Anyone can give an idea on how this can be reset?
>
> drop view table1
> *
> ERROR at line 1:
> ORA-00604: error occurred at recursive SQL level 1
> ORA-01000: maximum open cursors exceeded
>
> Thanks
> --
> Nandakumar
> Systems Analyst
> New York
> (N.Kumar_at_rocketmail.com)
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Tue Aug 03 1999 - 07:21:55 CDT