RE: dbv problems related to ora-0600 [4511]
- From: Jeroen van Sluisdam <jeroen.van.sluisdam@xxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 9 Apr 2004 17:11:36 +0200
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@xxxxxxxxxx]
Verzonden: Friday, April 09, 2004 5:02 PM
Aan: 'oracle-l@xxxxxxxxxxxxx'
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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
