查询的是非当前用户
SYS@oraods SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','SG186PMS_ODS_HB.PM_CBM_SBTZ')FROM DUAL;
ERROR:
ORA-31603: object "SG186PMS_ODS_HB.PM_CBM_SBTZ" of type TABLE not found in schema "SYS"
ORA-06512: at "SYS.DBMS_METADATA", line 1886
ORA-06512: at "SYS.DBMS_METADATA", line 1923
ORA-06512: at "SYS.DBMS_METADATA", line 2240
ORA-06512: at "SYS.DBMS_METADATA", line 3136
ORA-06512: at "SYS.DBMS_METADATA", line 4787
ORA-06512: at line 1
no rows selected
SYS@oraods SQL> SELECT DBMS_METADATA.GET_DDL('TABLE','PM_CBM_SBTZ')FROM DUAL;
ERROR:
ORA-31603: object "PM_CBM_SBTZ" of type TABLE not found in schema "SYS"
ORA-06512: at "SYS.DBMS_METADATA", line 1886
ORA-06512: at "SYS.DBMS_METADATA", line 1923
ORA-06512: at "SYS.DBMS_METADATA", line 2240
ORA-06512: at "SYS.DBMS_METADATA", line 3136
ORA-06512: at "SYS.DBMS_METADATA", line 4787
ORA-06512: at line 1
解决:
SELECT DBMS_METADATA.GET_DDL('TABLE','PM_CBM_SBTZ','SG186PMS_ODS_HB')FROM DUAL;
('类型','表名',‘用户’)
出现显示不全
set long 1000