SQL> select dbms_metadata.get_ddl('TABLESPACE','TEST') from dual;

CREATE TABLESPACE "TEST" DATAFILE

'/home/oracle/TEST/TEST.dbf' SIZE 52428800

LOGGING ONLINE PERMANENT BLOCKSIZE 8192

EXTENT MANAGEMENT LOCAL TESTALLOCATE SEGMENT SPACE MANAGEMENT MANUAL

ALTER DATABASE DATAFILE

'/home/oracle/TEST/TEST.dbf' RESIZE 2097152000

查看建立用户语句

SQL> select dbms_metadata.get_ddl('USER','TEST') from dual;

CREATE USER "TEST" IDENTIFIED BY VALUES '90CEB80324B4BC3D'

DEFAULT TABLESPACE "TEST"

TEMPORARY TABLESPACE "TEMP"

查看一个用户的授权相关信息

SQL> SELECT DBMS_METADATA.GET_GRANTED_DDL('ROLE_GRANT','TEST') from dual;

GRANT "CONNECT" TO "TEST"

GRANT "RESOURCE" TO "TEST"

SQL> SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','TEST') from dual;

GRANT CREATE ANY SYNONYM TO "TEST"

GRANT CREATE SYNONYM TO "TEST"

GRANT SELECT ANY TABLE TO "TEST"

GRANT LOCK ANY TABLE TO "TEST"

GRANT DROP ANY TABLE TO "TEST"

GRANT ALTER ANY TABLE TO "TEST"

主要是用于查询一些对象的创建语句。

ITPub博客

关于dbms_metadata.get_ddl的认识