Re: dbms_metadata.get_ddl Error

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_at_yahoo.com> 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.
>
>

--
http://www.freelists.org/webpage/oracle-l