Oracle Metadata explorer Indexes (5.2)

Question

Why would indexes not appear in the explorer?   The index node is there, but none of the indexes appear under it.   Using the same credentials on the Oracle (10g) instance/schema, I can reverse out all the DDL for a table indexes/keys/constraints/trigger/etc. using Quest TOAD.   Could this be a missing required permission??

Answer 1

Hello,

Please read the following post:

http://blogs.msdn.com/b/ssma/archive/2010/08/27/migrating-oracle-s-sample-hr-schema.aspx

Hope this help.

Regards,

Alberto Morillo
SQLCoffee.com