Maybe you can use UTL_FILE
Ivo Libal
> -----Urspr=FCngliche Nachricht-----
> Von: Boivin, Patrice J [SMTP:BoivinP_at_mar.dfo-mpo.gc.ca]
> Gesendet am: Donnerstag, 10. August 2000 18:32
> An: Multiple recipients of list ORACLE-L
> Betreff: serverouput buffer overflow
>=20
> Does anyone know how I can work around the 1000000 limit for server
> output?
>=20
> 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.
>=20
> Unfortunately there is so much information generated in the cursor =
that
> when
> I use dbms_output to produce the SQL, I reach the limit.
>=20
> Sqlplus only seems to spool once the command has finished, in this =
case
> until the whole PL/SQL loop has finished.
>=20
> I would prefer not having to break up the job into smaller cursors.
>=20
> TIA
> Patrice Boivin
> Systems Analyst (Oracle Certified DBA)
>=20
> Systems Admin & Operations | Admin. et Exploit. des syst=E8mes
> Technology Services | Services technologiques
> Informatics Branch | Direction de l'informatique=20
> Maritimes Region, DFO | R=E9gion des Maritimes, MPO
>=20
> --=20
> Author: Boivin, Patrice J
> INET: BoivinP_at_mar.dfo-mpo.gc.ca
>=20
> 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).
Received on Thu Aug 10 2000 - 12:04:53 CDT
