SYS.YUDONG>desc tab;
Name
Null?Type
----------------------------------------------------------------------------- -------- ----------------------------------------------------
TNAME
NOT NULL VARCHAR2(30)
TABTYPE
VARCHAR2(7)
CLUSTERID
NUMBER
SYS.YUDONG>SET LONG 999999
SYS.YUDONG>SELECT DBMS_METADATA.GET_DDL('VIES','TAB') FROM DUAL;
ERROR:
ORA-31600: invalid input value VIES for parameter OBJECT_TYPE in function GET_DDL
ORA-06512: at "SYS.DBMS_METADATA", line 2576
ORA-06512: at "SYS.DBMS_METADATA", line 2627
ORA-06512: at "SYS.DBMS_METADATA", line 4220
ORA-06512: at line 1
no rows selected
SYS.YUDONG>SELECT DBMS_METADATA.GET_DDL('VIEW','TAB') FROM DUAL;
DBMS_METADATA.GET_DDL('VIEW','TAB')
--------------------------------------------------------------------------------
CREATE OR REPLACE FORCE VIEW "SYS"."TAB" ("TNAME", "TABTYPE", "CLUSTERID"
AS
select o.name,
decode(o.type#, 2, 'TABLE', 3, 'CLUSTER',
4, 'VIEW', 5, 'SYNONYM'), t.tab#
fromsys.tab$ t, sys.obj$ o
where o.owner# = userenv('SCHEMAID')
and o.type# >=2
and o.type# <=5
and o.linkname is null
and o.obj# = t.obj# (+)
1 row selected.
|