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
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