dbms_metadata.get_ddl Error
- From: A Ebadi <ebadi01@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sun, 14 Oct 2007 22:28:56 -0700 (PDT)
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.
Other related posts:
