Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g89F6Yg13720 for ; Mon, 9 Sep 2002 11:06:34 -0400 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id IAA61070; Mon, 9 Sep 2002 08:06:27 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 004CB000; Mon, 09 Sep 2002 07:58:37 -0800 Message-ID: Date: Mon, 09 Sep 2002 07:58:37 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Mark Leith" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Mark Leith" Subject: RE: Recreate database script Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit DBATool will fix this problem for you, as well as a whole host of added features for database creation scripts, such as "rule" based storage attribute changes for example - e.g. change ALL indexes in a schema to be stored in an INDEXES tablespace. You can also use it to create HTML based DDL documentation for your schemas instead of spooling creation scripts.. You can find out more, or download a copy from: http://www.cool-tools.co.uk/products/dbatool.html It's free as well.. ;) HTH Mark =================================================== Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: mark@cool-tools.co.uk =================================================== http://www.cool-tools.co.uk Maximising throughput & performance -----Original Message----- Sent: 09 September 2002 16:33 To: Multiple recipients of list ORACLE-L If you export with rows=n, you get a text file with all the ddl to recreate the exportable objects. However, packages/procedures are formatted and not at all easy to use to recreate and the storage clauses are all in bytes. Not a pretty method, but certainly one that can be used. -----Original Message----- Sent: Friday, September 06, 2002 3:59 PM To: Multiple recipients of list ORACLE-L Export can do this. Right? But the output is not a script but a binary file only Import can understand. ltiu Connie Milliken wrote: >Does anyone have a script that will write another script to recreate a >particular database quickly with all the info specific to that particular >database? > >Seems to me that I have seen this somewhere before, but I am not sure where. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: ltiu@alumni.sfu.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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: Dan.Fink@mdx.com 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@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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: mark@cool-tools.co.uk 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@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).