On Tue, 28 Jun 2005 01:54:48 +0800, "alex" <whocare_at_s.org> wrote:
>I am learning the DBMS_LOB.
>
>After I've opened a BLOB in my anonymous block, I tried to do something on
>it that resulted in an exception. My close wasnt executed. I fixed the
>error, retry, encountered more exceptions, re-fixed it. Finally, it says:
>
>ORA-22290: operation would exceed the maximum number of opened files or LOBs
>
>It seems that I have missed the close too many times.
>
>My question is: Is there any ways to view and close all the files that I
>have open in my session for far?
>
--
Sybrand Bakker, Senior Oracle DBA
Received on Mon Jun 27 2005 - 13:50:09 CDT
