HI,
I have an Oracle RDBMS 12c EE.
User A owns indexes. I use user B (B=OZG_OWNER) to extract index DDL from M using SYS.DBMS_METADATA.
But the I get error:
ORA-31603: Object "I_TS1" van het type INDEX is niet gevonden in het schema "OZG_OWNER".
ORA-06512: in "SYS.DBMS_METADATA", regel 6078
ORA-06512: in "SYS.DBMS_METADATA", regel 8686
ORA-06512: in regel 1
ORA-06512: in regel 9
It seems to be related to Bug 3960099.
Even when I grant SELECT_CATALOG_ROLE and ensure that this role is the default role for user B, I still get the same error.
Does someone faced this problem? Is there a workaround (other than being logged as SYS user)?
Thanks by advance for any tip.
Kind Regards