Re: Info on Reverse Engineering Indexes

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
Received on Fri Mar 06 1998 - 00:00:00 CST