Wednesday 19 May 2010

Script to create definition of indexes

declare
s varchar2(4000);
begin
for c1 in (
select dbms_metadata.get_ddl(object_type=>'INDEX',name=>cur.index_name)
from user_indexes)
loop
s := dbms_metadata.get_ddl(object_type=>'INDEX',name=>c1.index_name);
end loop;
dbms_output.put_line('S= 's);
end;

No comments:

Post a Comment