Re: is rebuilding indexes necessary after import?
- From: "Mark J. Bobak" <mark@xxxxxxxxx>
- To: sjaffarhussain@xxxxxxxxx
- Date: Wed, 22 Dec 2004 02:37:25 -0500
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
