Oracle Database Discussions

Hi gurus,

here I go with a new question:

i have two databases 11.2.0.3 (PROD) and 11.2.0.1 (test), both under redhat 5.3. Test database was just created without any rows, users, .... I did a expdp from PROD of one schema to TEST. All was right, and the impdp was successfull too.

I checked the new schema and i get some different, i had 11 strange indexes on PROD but not in TEST:

in prod

SQL> SELECT COUNT(*) FROM DBA_INDEXES WHERE OWNER='MSG';

  COUNT(*)
----------
       432

SQL> select count(*) from dba_objects where object_type='INDEX' and owner='MSG';

  COUNT(*)
----------
       432

in TEST

SQL> SELECT COUNT(*) FROM DBA_INDEXES WHERE OWNER='MSG';

  COUNT(*)
----------
       432

SQL> select count(*) from dba_objects where object_type='INDEX' and owner='MSG';

  COUNT(*)
----------
       421

I get 11 objects more from PROD, this objects is marked like indexes but do not exist in dba_indexes. This indexes are on LOB datatypes:


SQL> select index_name, owner, table_name from dba_indexes where index_name like '%SYS_I%' and owner ='MSG';
INDEX_NAME OWNER TABLE_NAME
------------------------------ ------------------------------ --------------------------------------------------
SYS_IL0000155276C00003$$ MSG MSG_600
SYS_IL0000155269C00008$$ MSG USER_ST
SYS_IL0000155263C00006$$ MSG ST_VLT
SYS_IL0000155266C00007$$ MSG USER_CASHIER
SYS_IL0000155248C00023$$ MSG MAY_JP
SYS_IL0000155245C00025$$ MSG PR
SYS_IL0000155260C00005$$ MSG DCF
SYS_IL0000155257C00010$$ MSG REQUEST
SYS_IL0000155254C00002$$ MSG MESSAGES
SYS_IL0000155251C00002$$ MSG CREATE$JAVA$LOB$TABLE
SYS_IL0000155272C00013$$ MSG ID3



I check on dba_ind_columns on PROD but this indexes doesn't appear.

any idea of what are this indexes? maybe they didn't was exported? maybe is the different of databases version?

thanks for your time.