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

  • From: "Ankur Shah" <ankur_ora@xxxxxxxxxxx>
  • To: <askdba@xxxxxxxxxxxxx>, "mizan rahman" <callhimel@xxxxxxxxx>, <dba_gurus@xxxxxxxxxxxxxxx>
  • Date: Tue, 28 Dec 2004 10:32:11 -0500

U can also get the index list by running a import of an old export with
option

INDEXFILE   :  write table/index info to specified file

=========================================

HTHU
Ankur Shah
Oracle DBA
DHR-GA


----- Original Message -----
From: "Nisar Tareen" <ntareen@xxxxxxxxx>
To: "mizan rahman" <callhimel@xxxxxxxxx>; <dba_gurus@xxxxxxxxxxxxxxx>
Cc: "askdba" <askdba@xxxxxxxxxxxxx>
Sent: Tuesday, December 28, 2004 9:54 AM
Subject: [askdba] Re: [dba_gurus] how to re create index


> 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: