-
DBMS_METADATA.get_ddl error
Hi,
While running the following SQL I am getting the error ..
Any idea why this is occurring .. and how to prevent it ..
1 SELECT DBMS_METADATA.get_ddl('CONSTRAINT'
2 ,constraint_name)
3* FROM all_constraints
SQL> /
ERROR:
ORA-31603: object "SYS_C00532" of type CONSTRAINT not found in schema
"EDW_2_3_0"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 628
ORA-06512: at "SYS.DBMS_METADATA", line 1221
ORA-06512: at line 1
no rows selected
Thanks in advance
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|