write a pl/sql procedure and use the utl_file procedure to write to a file
on disk
>From: "Boivin, Patrice J" <BoivinP_at_mar.dfo-mpo.gc.ca>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: serverouput buffer overflow
>Date: Thu, 10 Aug 2000 08:31:53 -0800
>
>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 - 11:02:39 CDT
