SQL> SELECT DBMS_METADATA.GET_DDL('TABLE', 'EXT_BIGTBL_DP') FROM DUAL;
ERROR:
ORA-31603: object "EXT_BIGTBL_DP" of type TABLE not found in schema "SYS"
ORA-06512: at "SYS.DBMS_METADATA", line 2625
ORA-06512: at "SYS.DBMS_METADATA", line 2668
ORA-06512: at "SYS.DBMS_METADATA", line 2983
ORA-06512: at "SYS.DBMS_METADATA", line 3897
ORA-06512: at "SYS.DBMS_METADATA", line 5678
ORA-06512: at line 1no rows selectedElapsed: 00:00:00.04
数据库:ORACLE 11GR2
系统:RHEL6.4
ERROR:
ORA-31603: object "EXT_BIGTBL_DP" of type TABLE not found in schema "SYS"
ORA-06512: at "SYS.DBMS_METADATA", line 2625
ORA-06512: at "SYS.DBMS_METADATA", line 2668
ORA-06512: at "SYS.DBMS_METADATA", line 2983
ORA-06512: at "SYS.DBMS_METADATA", line 3897
ORA-06512: at "SYS.DBMS_METADATA", line 5678
ORA-06512: at line 1no rows selectedElapsed: 00:00:00.04
数据库:ORACLE 11GR2
系统:RHEL6.4
ORGANIZATION EXTERNAL
(
TYPE ORACLE_DATAPUMP
DEFAULT DIRECTORY EXTDIR
LOCATION('EXT_BIGTBL_DP.DMP')
)
AS SELECT * FROM OBJECTS;
通过DBMS_METADATA.GET_DDL函数生成创建语句:SELECT DBMS_METADATA.GET_DDL('TABLE', 'EXT_BIGTBL_DP') FROM DUAL;刚执行过这些了.