Index problem

[kgshangs]

Hi,

Here I am doing migration operation.
(migrating from orale 7.2 to oracle8i).
Shall I do show=y and indexfile=xxwhen I import the data to the Oracle 8i database.
If I do like this I will get the index definition script.

After that I am planning to remove the Index from Oracle8i database. Then I have to execute the script.I belive this will improve the perfromance.

If anybody knows better than this,

please reply me,my id is shankar_gk@hotmail.com
kgshangs@yahoo.com

plz reply with ur email id and name .
bye,

G.shankar.

[rohitsn]

Hi,
Yes dropping and recreating the index will obviously increase the performance as ur deleted leaf blocks will be removed from ur index and ur index will become more compact and there will be no fragmentation.
U can perform the follwing steps to drop and recreate the index

exp sys@plan_mts file=full.dmp log=full.log full=y rows=y indexes=y grants=y consistent=y statistics=none

imp sys@plan_mts file=full.dmp log=full_imp.log rows=n indexes=n show=y indexfile=crtindex.sql

Then u drop all ur existing indexes in Oracle 8i database and run the crtindex.sql script to recreate the ones.

In case of any help needed please be free to ask me at rohitsn@altavista.com

Regards,
ROhit Nirkhe,Oracle DBA,OCP 8i
rohitsn@altavista.com