Re: Info on Reverse Engineering Indexes

Not quite correct. This will create an indexfile "y.sql" (because of "indexfile=y" parameter). If you want an indexfile "abc.out" you have to specify "indexfile=abc.out".

By the way, there is a known bug in this utility under Solaris 2.x: the last line does not have a 0x0a at the end meaning there is no line terminator. If you process the so-generated indexfile further with tools like awk or sed, the last line is not recognized as a text line altogether. Workaround: do a "echo >>abc.out" after the imp command.

Martin Haltmayer

Jerry Gitomer wrote:
>
> 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
Received on Mon Mar 02 1998 - 00:00:00 CST