Re: Index Questions

On Tue, 13 Jul 2004 21:37:44 -0700, David Fitzjarrell wrote:

> You might find such code in DBA_SOURCE, or USER_SOURCE. Alternatively
> you can export the schema then run imp with the indexfile parameter:
>
> imp user/pass file=mydat.dmp full=y indexfile=mydat.sql
>
> then peruse the file created. It will be chock full of CREATE INDEX
> statements.

Exporting with "rows=no" will make export/import run slightly faster, especially for databases in TB range. Also, there is a freeware utility called DataBee (http://www.databee.com/), which can regenerate most of of the SQL statements for the objects in the schema. It's an excellent utility which even works under Linux/WINE combination. It is a utility which works on a .dmp file and doesn't require connection to oracle. It's blindingly fast.

-- 
A city is a large community where people are lonesome together.