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: Info on Reverse Engineering Indexes

Re: Info on Reverse Engineering Indexes

From: S Chavali <nospam_at_iname.com>
Date: 1998/03/06
Message-ID: <35005CF3.537D8E80@iname.com>#1/1

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

Original text of this message

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