SQL> set long 1000
SQL> select dbms_metadata.get_ddl('TABLESPACE','PMMS_DATA') from dual;
DBMS_METADATA.GET_DDL('TABLESP
--------------------------------------------------------------------------------
CREATE TABLESPACE "PMMS_DATA" DATAFILE
'/u01/oracle/oradata/TIGER/PMMS_DATA_001.DBF' SIZE 2147483648
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE DEFAULT
NOCOMPRESS SEGMENT SPACE MANAGEMENT AUTO
SQL>
dbms_metadata.get_ddl
最新推荐文章于 2024-04-09 09:37:52 发布