2011-12-06から1日間の記事一覧
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 -----------------------------…
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 -----------------------------…