Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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.Received on Wed Jul 14 2004 - 06:04:18 CDT