How are you calling dbms_metadata.get_ddl (i.e. are you passing the correct schema to it)? second, the calling user does have the rights to do this on the index's schema? rgds On 10/15/07, A Ebadi <ebadi01@xxxxxxxxx> wrote: > > We have a procedure which calls dbms_metadata.get_ddl to get the ddl for > an index & this works fine for objects (indexes) owned by the same user as > my procedure. For all other objects I get the error below. I have an SR > open with Oracle for several days now, but no solution has been given. Any > advise would be appreciated. > > Environment: Oracle 10.2.0.3.0 on Sun Solaris 2.10. > > Here is the error: > ORA-31603: object "MY_TAB_IDX5" of type INDEX not found in schema > "OPS$ORACLE" > > Thanks, > Abdul > > ------------------------------ > Be a better Heartthrob. Get better relationship answers > <http://us.rd.yahoo.com/evt=48255/*http://answers.yahoo.com/dir/_ylc=X3oDMTI5MGx2aThyBF9TAzIxMTU1MDAzNTIEX3MDMzk2NTQ1MTAzBHNlYwNCQUJwaWxsYXJfTklfMzYwBHNsawNQcm9kdWN0X3F1ZXN0aW9uX3BhZ2U-?link=list&sid=396545433>from > someone who knows. > Yahoo! Answers - Check it out. > >