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@xxxxxxxxx
"Science is the belief in the ignorance of experts."  --Richard P.
Feynman


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

Other related posts: