[askdba] Re: [dba_gurus] how to re create index
- From: "Ankur Shah" <ankur_ora@xxxxxxxxxxx>
- To: <askdba@xxxxxxxxxxxxx>, "mizan rahman" <callhimel@xxxxxxxxx>
- Date: Tue, 28 Dec 2004 10:35:28 -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:
