Hi! If even Oracle hasn't seen this error, then probably we can't help much here either. Just a wild guess, try to move this partition to another location and select from it then (although koxsisz1 isn't a data layer error as far as I understand). Try to read using index if available, then using full hint etc..
Tanel. ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, September 18, 2003 3:04 AM > This is not my week ... > > Has anyone seen anything like this > > select value from chanarch_nlc.old_archive_wave_i partition (SEP1603) where pv_id = > * > ERROR at line 1: > ORA-00600: internal error code, arguments: [koxsisz1], [1], [], [], [], [], [], > [] > > I have Oracle support working on the problem. They say they have never seen such an error before. Oracle though often tells me that. The table looks like > > Name Null? Type > ----------------------------------------- -------- ----------------------- ----- > PV_ID NUMBER(38) > TIMESTAMP DATE > NANOSECS NUMBER(9) > STAT NUMBER(8) > SEVR NUMBER(8) > OSTAT NUMBER(16) > VALUE CHANARCH_NLC.INT_VALUES > > The last column is a varray. I can retrieve any of the other columns from that partition. > I can also retrieve the value column from any partition before September 11, 2003. > Any partition after that fails with the 0ra-600 error when the value column is selected. > > DBV at first gave errors along the lines of > > BV-00102: File I/O error on FILE > (/u9/oradata/NLCO/chanarch_nlc_active_data01.dbf) during end read op > eration (-1) > > The file is 2018 MB in size. But resizing the files downwards and back up again fixed > That problem. The files are allowed to autoextend with 2018 being the maximum size. > > This is not the same database which had the RAID problem. > > Ian MacGregor > Stanford Linear Accelerator Center > [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: MacGregor, Ian A. > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
