Re: Info on Reverse Engineering Indexes

Hi Nancy,

Check out the Oracle Export and Import utilities. Doing an export and then doing an import with indexfile=y (I think that's the right name, but you can look it up in the Server Utilities manual in the chapter on import). This will create a file containing the DDL needed to create all of the indexes as an executable sql script. A free bonus is that the DDL needed to create the tables is included as comments. So, if you want, you can edit the file and be able to recreate all of your tables and indexes.

Regards

Jerry

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
 

-- 
Jerry Gitomer		Since I know how to spell DBA I became one. 
jgitomer_at_p3.net