Dear Weerd Kirsten,
Its from archive,Its not mine but work perfectly.
Hope this helps.
Ragards,
Rajanish Joshi
DBA,Pune
------------------------start of file---------------------------------
set term off
set echo off
set concat +
spool &1+_&2.sql
set concat .
set feedback off
set heading off
set pagesize 0
set ver off
select 'create ' || decode(uniqueness,'UNIQUE','UNIQUE',' ') ||
' index ' ||owner||'.'||index_name|| ' on ' ||
table_owner || '.'||
table_name || '('
from sys.dba_indexes where owner= '&&1' and index_name = '&&2'
/
select decode(column_position,'1',' ',',')|| column_name
from sys.dba_ind_columns
where index_owner = '&&1' and index_name = '&&2'
order by column_position
/
select ' ) tablespace ' || tablespace_name
|| ' initrans ' || ini_trans
|| ' maxtrans ' || max_trans
from sys.dba_indexes where owner= '&&1' and index_name = '&&2'
/
select ' storage ( initial '|| initial_extent
from sys.dba_indexes where owner= '&&1' and index_name = '&&2'
/
select ' next '|| next_extent
from sys.dba_indexes where owner= '&&1' and index_name = '&&2'
/
select ' minextents '||min_extents
|| ' maxextents '||max_extents
|| ' pctincrease '|| pct_increase || ');'
from sys.dba_indexes where owner= '&&1' and index_name = '&&2'
/
spool off
exit
----------------------------------end of file----------------------------
__________________________________________________
Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
Received on Mon Dec 04 2000 - 13:18:51 CST