Extract ddl with "dbms metadata.get ddl"

From dbawiki
Revision as of 20:28, 6 December 2011 by 127.0.0.1 (talk) (Created page with " set pagesize 0 set linesize 30000 set long 500000 set longchunksize 500000 set trimspool on set feed off select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
set pagesize 0
set linesize 30000
set long 500000
set longchunksize 500000
set trimspool on
set feed off
select 'select dbms_metadata.get_ddl(INDEX,||object_name||,&&schema)||chr(10)||/ from dual;'
from dba_objects where owner = UPPER('&&schema')
and object_type = 'INDEX'
and ...
/