Re: Extracting DLL

From: Oracleguru, Suresh Bhat <oracleguru_at_mailcity.com>
Date: Tue, 16 Mar 1999 17:19:32 GMT
Message-ID: <01be6fe0$8dd29c20$a504fa80@mndnet>

Hi Doug,

To generate script for ALL tables, indexes, constraints,grants, table triggers with appropriate ( must have export file with COMPRESS = Y ) storage parameters use:

imp indexfile = y

along with other import parameters.

Later !!!

Oracleguru
www.oracleguru.net
oraclegur_at_mailcity.com

Doug Cowles <dcowles_at_bigfoot.com> wrote in article <36EE7A36.5597C3B1_at_bigfoot.com>...
> Can anyone point me to a script that will extract the ddl from
> an Oracle database? This would include table definitions,
> constraints, and well as storage parameters. I can easily
> get the table definitions from an indexfile, and I can get
> the constraints from a separate script, but it would be nice to
> get the whole deal in one output.
>
> - Dc.
>
>
Received on Tue Mar 16 1999 - 11:19:32 CST