Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Info on Reverse Engineering Indexes
Yuri Ludevig wrote:
> You can use Erwin by Logic Works. It allows you to extract DDL fomr the
> existing DB.
> Yuri
>
> Nancy Popp wrote:
>
> > Hi,
> > I'm new to the Oracle Newsgroup and apologize if this has already
> > been asked.
> > Is there a place where I can get a sql script which reverse engineers
> > indexes from a user schema? We need to generate a year 2000
> > test environment, and we can't make it the same size as production
> > We are looking for the reverse engineered ddl, so that we can edit
> > the STORAGE clause.
> >
> > Thanks,
> > Nancy
If I'm not mistaken these is such a script at http://www.oramag.com/html/depot.html
-- hope this helps ! Srini (to reply, change "nospam" to "chavali" in my email address. :-) )Received on Fri Mar 06 1998 - 00:00:00 CST