Differences in Indexes ! help please

[Striker99]

All,

I am using Oracle7.3.4. When i connect sqlplus as system/manager and list all the application related indexes from dba_indexes it shows about 700 indexes on the database. But when i export the database and then import using INDEXFILE=filename.txt, it shows only about half of the indexes only !

Anyidea why. I checked the status and all the the 700 indexes are valid/active.

thanks,
striker99

 

[lokesh123]

Check out the space allocated for indexes in your database, guess you do not have sufficient space in your database for indexes

 

[JamesGordon]

Out of the 700 indexes a lot will be primary and unique constraints. These will be in the 'create table' statements and not actual 'create index' statements. So if you total up all your create index, primary key and unqiue key statements it should add up to 700.