you can use utl_files in 7.3.4 as well.....
>From: Brian_McQuillan_at_gelco.com
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: serverouput buffer overflow
>Date: Thu, 10 Aug 2000 09:06:13 -0800
>
>Patrice,
>
>I don't think there is a way round the buffer limit, I take it you are
>using
>DBMS_OUTPUT to do this.
>If you are on 8.x have you considered utl files, there's no limit execpt
>what
>space you left on your OS
>
>hope it helps
>Brian.
>
>
>
>
>
>"Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca> on 08/10/2000 12:31:52 PM
>
>Please respond to ORACLE-L_at_fatcity.com
>
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>cc: (bcc: Brian McQuillan/GELCO)
>
>
>
>
>Does anyone know how I can work around the 1000000 limit for server output?
>
>I have a cursor that makes a list of all the indexes in a database, then I
>use that to generate sql to file to analyze them in turn plus store their
>sizing info into a separate table.
>
>Unfortunately there is so much information generated in the cursor that
>when
>I use dbms_output to produce the SQL, I reach the limit.
>
>Sqlplus only seems to spool once the command has finished, in this case
>until the whole PL/SQL loop has finished.
>
>I would prefer not having to break up the job into smaller cursors.
>
>TIA
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)
>
>Systems Admin & Operations | Admin. et Exploit. des syst
>
>èmes
>Technology Services | Services technologiques
>Informatics Branch | Direction de l'informatique
>Maritimes Region, DFO | Région des Maritimes, MPO
>
>--
>Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
>
>
>
>
Get Your Private, Free E-mail from MSN Hotmail at
http://www.hotmail.com
Received on Thu Aug 10 2000 - 20:06:23 CDT
