dbv problems related to ora-0600 [4511]

From: Jeroen van Sluisdam <jeroen.van.sluisdam_at_vrijuit.nl>
Date: Fri, 9 Apr 2004 17:02:18 +0200
Message-ID: <727A513477946E4380C23DD63C36FCC026BB3C@pedro.vrijuit.nl>

Hi,  

We're busy building a datawarehouse db.
We encountered an ora-0600 [4511] all other arguments empty Based on the app we could determine the table in question. Analyze table validate structure cascade reported block corruption  

Metalink suggested db_block_size 32k can containt too many rows in a block and pct_free should be increased. I run dbv on this file and it reports 3 pages as corrupt.  

I created a new table like the old one, pctfree on 20 inserted all data from the old table, ran another analyze validate structure and problem was gone, but dbv still reports the same corruption.  

Can I live with these errors, any other ways to continue on??  

Tia,  

Jeroen

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Fri Apr 09 2004 - 10:40:00 CDT