"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> ¦b¶l¥ó
news:c3h0c1lr6i62muvofo27tdjrvkkb907vos_at_4ax.com ¤¤¼¶¼g...
> 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?
> >
>
> A bit of RTFM learns there is a DBMS_LOB.FILECLOSEALL procedure.
> As you didn't post any code you are struggling with (which you should
> have done) I assume this will help you.
>
>
> --
> Sybrand Bakker, Senior Oracle DBA
Ah, thx for your help.
Received on Mon Jun 27 2005 - 13:58:38 CDT
