Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Prod
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for 32-bit Windows: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
SOURCE O/S : Win 2003
My TARGET DB
Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production
PL/SQL Release 220.127.116.11.0 - Production
CORE 18.104.22.168.0 Production
TNS for 64-bit Windows: Version 22.214.171.124.0 - Production
NLSRTL Version 126.96.36.199.0 - Production
TARGET O/S : WIN 2008 R2
I am in process of upgrading from 10g to 11g. I am following route of DataPump, since we can afford downtime and it's less than 10 gb db. I took a datapump for all of my user schemas from 10g box and imported it in 11g. Except for 1 function compilation error everything went fine.
Out of curiosity i started looking into dba_objects on 10g and 11g against user schemas and found that somehow the no. of indexes that dba_objects reports on 10g is less than 11g system.I then checked dba_indexes and surprisingly both 10g and 11g shows me same count.
It gives me impression that somehow dba_objects in 10g box is not good as far as Indexes are concerned. As far as i know the moment you create a index it inserts a records in dba_indexes as well as dba_objects. ... but in my case there is a mismatch as far as indexes are concerned.
One more thing that i have noticed that the indexes which are not present in 10g box in dba_objects table are SYSTEM generated index like SYS_IL0000015381C00009$$
Can anyone provide me some pointers... is my assumption correct that dba_objects is not good on 10gbox.
Pl post complete export and import commands used, along with the first 20 lines of the export and import logs. Were any errors reported in the logs ? If not, your process should be good. The SYS_IL% are LOB Indexes.