oracle - 从整个Oracle DB获取DDL的有效方式

Question

目前 Oracle 11.1 数据库中大约有 30 个表。

有没有办法用一个命令生成所有的ddl？ (或者一些命令？)

编辑:
根据以下建议，我尝试了:

SELECT dbms_metadata.get_ddl( 'TABLE', table_name, owner )
  FROM all_tables;

并得到:

ORA-31603: object "HS_PARTITION_COL_NAME" of type TABLE not found in schema "SYS"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.DBMS_METADATA", line 3241
ORA-06512: at "SYS.DBMS_METADATA", line 4812
ORA-06512: at line 1
31603. 00000 -  "object \"%s\" of type %s not found in schema \"%s\""
*Cause:    The specified object was not found in the database.
*Action:   Correct the object specification and try the call again.

很明显， dbms_metadata 有一些非常基础的东西。我不明白。

Answer 1

以下是对我有用的内容:

SELECT dbms_metadata.get_ddl('TABLE', table_name)
  FROM user_tables;