Well ! U truncated. No more old indexes
Start fresh. Create indexes
As table is of 22m rows U definetely need indexes
If U haven't noted all index names on that table
go through one of the exp or imp logs
Rao
--
On Tue, 26 Sep 2000 17:41:12
Jared Still wrote:
>
>Truncating the table also truncates the indexes. Hence, no
>rowid's in the index immediately after truncation.
>
>Jared
>
>On Tue, 26 Sep 2000, LIST, DB wrote:
>
>> I certainly would. The rowid's in the index probably don't match.
>> However, analyze index validate structure may work...
>>
>> Me thinks, anyway
>>
>> Doug
>>
>>
>>
>> -----Original Message-----
>> Sent: Tuesday, September 26, 2000 12:51
>> To: Multiple recipients of list ORACLE-L
>>
>> One of our databases has a table with 22 million rows
>> in it that got corrupted data in it. In order to fix the corrupted
>> data, a temporary table was created, the data was written
>> to the temp table, cleansed, the original table was truncated,
>> and the clean data was written back to the original table
>> pretty much in primary key order.
>>
>> I think we need to drop and recreate or at least rebuild
>> the indexes now that the table has been truncated
>> and the data rewritten. A fellow DBA maintains that there
>> is no value in doing so. Surely performance will suffer
>> if we don't rebuild the indexes. Is this not true? How
>> much benefit will be get in dropping and recreating
>> the indexes as opposed to rebuilding them as opposed
>> to leaving them as is?
>>
>> Thanks,
>>
>> Cherie Machler
>>
>>
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author:
>> INET: Cherie_Machler_at_gelco.com
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>> --
>> Please see the official ORACLE-L FAQ: http://www.orafaq.com
>> --
>> Author: LIST, DB
>> INET: DB.LIST_at_bannerhealth.com
>>
>> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>> San Diego, California -- Public Internet access / Mailing Lists
>> --------------------------------------------------------------------
>> To REMOVE yourself from this mailing list, send an E-Mail message
>> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>> the message BODY, include a line containing: UNSUB ORACLE-L
>> (or the name of mailing list you want to be removed from). You may
>> also send the HELP command for other information (like subscribing).
>>
>
>
>Jared Still
>Certified Oracle DBA and Part Time Perl Evangelist ;-)
>Regence BlueCross BlueShield of Oregon
>jkstill_at_bcbso.com - Work - preferred address
>jkstill_at_teleport.com - private
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Jared Still
> INET: jkstill_at_bcbso.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
Received on Tue Sep 26 2000 - 21:50:45 CDT
