Re: Extracting DLL

Sorry -

My previous post should have said

        imp show = y

imp indexfile = y

generates script for existing indexes with commented create script for ALL tables with appropriate storage parameters. It does not give index script created via primary key constraints.

Suresh

Oracleguru, Suresh Bhat <oracleguru_at_mailcity.com> wrote in article <01be6fe0$8dd29c20$a504fa80_at_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:42:51 CST