[askdba] Re: [dba_gurus] how to re create index

  • From: Nisar Tareen <ntareen@xxxxxxxxx>
  • To: mizan rahman <callhimel@xxxxxxxxx>, dba_gurus@xxxxxxxxxxxxxxx
  • Date: Tue, 28 Dec 2004 06:54:01 -0800 (PST)

Mizan, 
 
I hope you mean that you have deleted the  index tablesapce,   If yes than it 
should not be a problem. 
 
 1 -   Create new table space. 
  2 -   Rebuild all the indexes in this new tablespace. 
 3 -    Following script should help you .   
 
--  Nisar Tareen 
--  REbuild  index  for Oracle Financial    Nov. 1998 
 
set termout off;
set pagesiz  3000;
-- set feedback off;
set linesiz  100;
set heading off;
-- set echo off;
spool  Run_rebuild_index.sql 
select  'alter index ' || owner || '.'||  index_name || ' rebuild unrecoverable 
tablespace user_ind_data;'
from dba_indexes
where owner in  ( 'EDBADM') 
order by owner;
spool off;
spool  rebuild_index_Trutrack.log 
@Run_rebuild_index.sql;
spool off;
 
 
Nisar Tareen 

mizan rahman <callhimel@xxxxxxxxx> wrote: 
Dear all,

mistekenly deleted the index dbf from os directory, now the data base still 
running, how to re create bac all the indexes.

please give a hand

thanks in advance
Mizan

            
---------------------------------
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.

[Non-text portions of this message have been removed]


Yahoo! Groups SponsorADVERTISEMENT


---------------------------------
Yahoo! Groups Links

   To visit your group on the web, go to:
http://groups.yahoo.com/group/dba_gurus/
  
   To unsubscribe from this group, send an email to:
dba_gurus-unsubscribe@xxxxxxxxxxxxxxx
  
   Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. 



                
---------------------------------
Do you Yahoo!?
 Jazz up your holiday email with celebrity designs. Learn more.


Other related posts: