表領域(TABLESPACE)の定義を DBMS_METADATA で抽出してみる

SQL は↓(※訳有って9iR2環境で実行)

SET PAGES 0;
SET LINESIZE 32767;
SET LONG 2000000;
SET LONGC 2000000;
COLUMN DDL FORMAT A32767;
SELECT DBMS_METADATA.GET_DDL('TABLESPACE','TEST1') AS DDL FROM DUAL;

結果は↓

DDL
---------------------------------------------------------------------------------

CREATE TABLESPACE "TEST1" DATAFILE
'/u01/oradata/ora9i/test1.dbf' SIZE 1258291200 REUSE
LOGGING ONLINE PERMANENT BLOCKSIZE 8192
EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT MANUAL

DBMS_METADATA 最高ォォオオオォオォォォッッッッ！！！