Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Generating SQL code for schema objects

Re: Generating SQL code for schema objects

From: Rich Mycroft <rich.mycroft_at_synchrologic.com>
Date: 2000/07/07
Message-ID: <9nj95.6023$%J6.12285@newsfeed.slurp.net>#1/1

Seems to me the Autl book (Oracle 8i Administration and Management - Wiley ISBN 0-471-35453-8) had some scripts for this kind of thing. It has a CD with the scripts from the book on it.

Rich Mycroft

"mkb" <mkb125NOmkSPAM_at_yahoo.com.invalid> wrote in message news:001760fa.e031dff7_at_usw-ex0107-055.remarq.com...
> i have a couple stored procs that go grab the tablespace, table
> and index ddl and dump out to the utl_file directory. not
> perfect, but they give you all the ddl. if anyone wants copies,
> email me at mkb125_at_yahoo.com
>
>
> -----------------------------------------------------------
>
> Got questions? Get answers over the phone at Keen.com.
> Up to 100 minutes free!
> http://www.keen.com
>
Received on Fri Jul 07 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US