Thursday, March 8, 2012

missing index after data pump import oracle

Missing index was found during validating imported schemas by querying dba_objects table.

However, index count from dba_indexes is same for both orginial schema and imported one. The problem is the LOB index. one database count it as index in dba_objets and the other is not.

the only differenct between the two database is the edition. One is standard edition and the other is Enterprise one.

No comments:

Post a Comment