RE: dbms_metadata.get_ddl Error

  • From: "Peter McLarty" <p.mclarty@xxxxxxxxxx>
  • To: <ebadi01@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 15 Oct 2007 16:07:31 +1000

I am going to guess, I know I am bad, that your MY_TAB_IDX5 index is on
another schema. You would have to prefix the object name with the schem
name so for schema name XD, that means you need  in your
DBMS_METDATA.get_ddl() staement XD.MY_TAB_IDX5 not MY_TAB_IDX5 without
the prefix.


From: A Ebadi [mailto:ebadi01@xxxxxxxxx] 
Sent: Monday, 15 October 2007 03:29 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: dbms_metadata.get_ddl Error

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 on Sun Solaris 2.10.
Here is the error:
ORA-31603: object "MY_TAB_IDX5" of type INDEX not found in schema


Be a better Heartthrob. Get better relationship answers
fMzYwBHNsawNQcm9kdWN0X3F1ZXN0aW9uX3BhZ2U-?link=list&sid=396545433> from
someone who knows.
Yahoo! Answers - Check it out. 

Other related posts: