构造表的语句
SQL> set pagesize 0
SQL> set long 999
SQL> select dbms_metadata.get_ddl('TABLE','A1') from dual;
CREATE TABLE "SYS"."A1"
( "A" NUMBER(38,0),
PRIMARY KEY ("A")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "TEST" ENABLE ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "TEST" 获取表空间的构建语句
SQL> select dbms_metadata.get_ddl('TABLESPACE','SYSTEM') from dual;
CREATE TABLESPACE "SYSTEM" DATAFILE
'F:\APP\YANG\ORADATA\ORACL\SYSTEM01.DBF' SIZE 314572800
AUTOEXTEND ON NEXT 10485760 MAXSIZE 32767M
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT MANUAL
ALTER DATABASE DATAFILE 'F:\APP\YANG\ORADATA\ORACL\SYSTEM01.DBF' RESIZE 786432000