Difference between revisions of "Extract ddl with "dbms metadata.get ddl""
From dbawiki
(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||...") |
|||
| Line 5: | Line 5: | ||
set trimspool on | set trimspool on | ||
set feed off | set feed off | ||
| − | + | ||
select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;' | select 'select dbms_metadata.get_ddl(''INDEX'','''||object_name||''',''&&schema'')||chr(10)||''/'' from dual;' | ||
from dba_objects where owner = UPPER('&&schema') | from dba_objects where owner = UPPER('&&schema') | ||
Revision as of 20:28, 6 December 2011
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 ...
/
