Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Why the index count is different even import completed successfully?

906790Nov 29 2012 — edited Dec 14 2012

Hi All,

I did the schema refresh successfully using expdp/impdp[11gR2] without any error. But while checking the count i can see the difference in index,please find the below for your reference and let me know the reason why its not exported /imported .

Source :
+++++++

OBJECT_TYPE COUNT(1)
------------------- ----------
SEQUENCE 17
PROCEDURE 2
DATABASE LINK 1
LOB 10
INDEX 31
TABLE 66

Target :
+++++++

OBJECT_TYPE COUNT(1)
------------------- ----------
SEQUENCE 17
PROCEDURE 2
DATABASE LINK 1
LOB 10
TABLE 66
INDEX 21

While checking in source schema i found the below indexes are not there in target schema.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

OWNER OBJECT_TYPE OBJECT_NAME CREATED
------------------------------ ------------------- ----------------------------------- ---------
EMP INDEX SYS_IL0000097754C00005$$ 01-MAR-12
EMP INDEX SYS_IL0000097735C00009$$ 01-MAR-12
EMP INDEX SYS_IL0000097735C00007$$ 01-MAR-12
EMP INDEX SYS_IL0000097740C00005$$ 01-MAR-12
EMP INDEX SYS_IL0000097743C00007$$ 01-MAR-12
EMP INDEX SYS_IL0000122314C00004$$ 06-APR-12
EMP INDEX SYS_IL0000123452C00007$$ 16-APR-12
EMP INDEX SYS_IL0000097746C00007$$ 01-MAR-12
EMP INDEX SYS_IL0000097749C00009$$ 01-MAR-12
EMP INDEX SYS_IL0000097749C00007$$ 01-MAR-12

Thanks
Bala