| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbv problems related to ora-0600 [4511]
Addional info is that the new data is located in a diffent file, I checked
this through
EM, but is the old block in the old file now unusable? If not can I force
this to happen
such that I cannot get problems in the future?
Regardsm
Jeroen
-----Oorspronkelijk bericht-----
Van: Jeroen van Sluisdam [mailto:jeroen.van.sluisdam_at_vrijuit.nl]
Verzonden: Friday, April 09, 2004 5:02 PM
Aan: 'oracle-l_at_freelists.org'
Onderwerp: dbv problems related to ora-0600 [4511]
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |