Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Missing indexes after import
Did you specify INDEXES in your either export or import command? If
all the indexes were exported successfully and you did not disable
indexes importing by mistake, most likely those indexes were related
to the primary keys. If a primary key constraint is added to a table
that already has an index on that column, the index will not be
created. Import create indexes first and then constraints. You can
play around with index and primary key constraint creation in SQLPLUS
to see how they behave. I heard there are some differences between 8i
and 9i as to how imp handles the constraint, index creation. Have not
gotten around to check it out though.
"Siegbert Kick" <SKick_at_t-online.de> wrote in message news:<aj2rls$30r$05$1_at_news.t-online.com>...
> Hallo,
>
> I have a problem with missing indexes after
> importing a dump-file with imp.exe.
>
> Note: the import has finished without any warnings
>
> Can anybody help me ?
>
> Thank you
Received on Sat Aug 10 2002 - 12:33:52 CDT