Re: is rebuilding indexes necessary after import?

No, because import does not really "import" indexes. It issues a create index statement. So, the indexes are freshly built at the end of an import.
-Mark

On Wed, 2004-12-22 at 02:12, Jaffar_DBA wrote:

> Hello list,
>
> I have a question. Lets say I have taken an export (full) and imported
> into another database (full import), including indexes. Do I have to
> rebuild all indexes again? Generally, to reorg. objects we use export
> and import to solve the issue. Somewhere in the metalink written that
> after importing, indexes, it is better to rebuild them or dont import
> indexes, after importing data just create indexes.
> My question is, do we really need to rebuild/recreate indexes after
> importing them into another database?
>
> Thank you in advance.
>
> --
> Best Regards,
> Jaffar, OCP DBA
> Banque Saudi Fransi
> Saudi Arabia

--
Mark J. Bobak
mark_at_bobak.net
"Science is the belief in the ignorance of experts."  --Richard P.
Feynman


--
http://www.freelists.org/webpage/oracle-l