Dear Experts,
I am trying to find meta data of the Object and its object type is "TYPE"
SQL> select distinct owner, object_name,object_type from dba_objects
where object_name like 'ST_DOMAIN_STATS';
OWNER OBJECT_NAME OBJECT_TYPE
-------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- -----------------------
SDE ST_DOMAIN_STATS TYPE BODY
SDE ST_DOMAIN_STATS TYPE
SQL> BEGIN
DBMS_OUTPUT.put_line (
DBMS_METADATA.get_ddl ('TYPE', 'SDE.ST_DOMAIN_STATS'));
END; 2 3 4
5 /
BEGIN
*
ERROR at line 1:
ORA-31603: object "SDE.ST_DOMAIN_STATS" of type TYPE not found in schema "SYS"
ORA-06512: at "SYS.DBMS_METADATA", line 6069
ORA-06512: at "SYS.DBMS_METADATA", line 8666
ORA-06512: at line 2
SQL> SELECT DBMS_METADATA.get_ddl ('TYPE', 'SDE.ST_DOMAIN_STATS')
FROM sys.dual;
ERROR:
ORA-31603: object "SDE.ST_DOMAIN_STATS" of type TYPE not found in schema "SYS"
ORA-06512: at "SYS.DBMS_METADATA", line 6069
ORA-06512: at "SYS.DBMS_METADATA", line 8666
ORA-06512: at line 1