Re: Database creation script anybody?

Nigel,

  Using dbms_output.put_line you may run into Buffer overflow error   as it is for limited use only where the no. of lines displayed is   less.

  In your case, since you are trying to use this for regenerating an   entire database and its objects, I suggest use UTL_FILE command   rather than dbms_output.

Regards
Rajagopal Venkataramany

----Original Message Follows----
From: Thomas.Nigel_at_viaginterkom.de
Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Database creation script anybody? Date: Tue, 02 May 2000 09:58:20 -0800

Hi Listers,

Does anybody out there have a database recreation script written in PL/SQL that
uses dbms_output.put_line to print the create database commands e.g. tablespace
creation lines.

The script should be run on an existing database to build each command.

Regards

Nigel T

--
Author:
   INET: Thomas.Nigel_at_viaginterkom.de

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