dbms_metadata.get_ddl Error

From: A Ebadi <ebadi01_at_yahoo.com>
Date: Sun, 14 Oct 2007 22:28:56 -0700 (PDT)
Message-ID: <549103.58853.qm@web51103.mail.re2.yahoo.com>

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 from someone who knows. Yahoo! Answers - Check it out.
--

http://www.freelists.org/webpage/oracle-l Received on Mon Oct 15 2007 - 00:28:56 CDT