test=# select dbms_metadata.GET_DDL('table','t1');

         get_ddl         

--------------------------

 CREATE TABLE PUBLIC.T1( +

  ID INTEGER             +

 )                       +

test=# select dbms_metadata.get_index_ddl('ind_t1','public');

                   get_index_ddl                  

---------------------------------------------------

 CREATE INDEX ind_t1 ON public.t1 USING btree (id)+

• 表，索引，存储过程的ddl

 SELECT DBMS_METADATA.GET_DDL(U.OBJECT_TYPE, u.object_name)   FROM USER_OBJECTS u  where U.OBJECT_TYPE IN ('TABLE','INDEX','PROCEDURE');

• 表空间的ddl语句

SELECT DBMS_METADATA.GET_DDL('TABLESPACE', TS.tablespace_name) FROM DBA_TABLESPACES TS;

• 创建用户的ddl

SELECT DBMS_METADATA.GET_DDL('USER',U.username)  FROM DBA_USERS U;