sqlplus打印表和表空间定义

set long 200000

--打印表定义

select dbms_metadata.get_ddl('TABLE','ACT_GE_BYTEARRAY','EULAR_DEV') from dual;

--打印表空间定义

select dbms_metadata.get_ddl('TABLESPACE','TAB_PAASTEST') from dual;

--打印用户权限

SELECT DBMS_METADATA.GET_DEPENDENT_DDL('OBJECT_GRANT','EMPLOYEES','HR') FROM DUAL;
SELECT DBMS_METADATA.GET_GRANTED_DDL('SYSTEM_GRANT','SCOTT') FROM DUAL;