*ORA-01578:*ORACLE data block corrupted (file # *string*, block # *string*) *Cause:*The data block indicated was corrupted, probably due to program errors.*Action:*Determine which object was corrupted using a command like the following: SELECT SEGMENT_TYPE,OWNER||'.'||SEGMENT_NAME FROM DBA_EXTENTSWHERE *file* = FILE_ID AND *block* BETWEEN BLOCK_ID AND BLOCK_ID+BLOCKS -1;
where values for *file* and *block* are from the message. Try to restore the segment containing the block indicated. This may involve dropping the segment and re-creating it. If there is a trace file, report the errors in it to Oracle Support Services. *ORA-01110:*data file *string*: '*string*'*Cause:*This message reports the file name involved with other messages.*Action:*See the associated messages for a description of the problem. On 2/28/06, Andy Siregar <[EMAIL PROTECTED]> wrote: > > Bung Yulius dan Rekan Oracle Mania, > > Mohon info untuk kasus di bawah ini. > > Sewaktu masuk ke schema browser TOAD, saya dapat error message : > > ----------------------------------------------------------------------------------------------- > ORA-01578: ORACLE data block corrupted (file # 1, block # 6447) > ORA-01110: data file 1: '/u02/oradata/DWH/system01.dbf' > > ----------------------------------------------------------------------------------------------- > Dengan query : > > SELECT segment_name , segment_type , owner , tablespace_name > FROM sys.dba_extents > WHERE file_id = 1 > AND 6447 BETWEEN block_id and block_id + blocks -1 > > saya dapat segmen yang error adalah I_OBJ2 yang merupakan index dari tabel > OBJ$ kepunyaan SYS. > > Apakah ada masalah kalau saya melakukan Rebuild atau DROP & CREATE ulang > INDEX I_OBJ2 ini? > > Pls, advise-nya. > > Salam, > Andy Siregar > Balikpapan. > > > > > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [EMAIL PROTECTED] > Website: http://indo-oracle.lizt.org (NEW) > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.vze.com > Yahoo! Groups Links > > > > > > > > [Non-text portions of this message have been removed] -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.lizt.org (NEW) ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.vze.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
