>We don't have the packages you said on our PROD database.
The package exists in 7.3 as well... why not installing it?
>SELECT SEGMENT_NAME, SEGMENT_TYPE, OWNER FROM SYS.DBA_EXTENTS WHERE >537037017 BETWEEN BLOCK_ID AND BLOCK_ID + BLOCKS - 1; > >This did not give me any result. My doubt is whether we can put the data block >address ( 537037017) in the above query !!! Is that right ?
You cannot use a DBA in this way. In fact the DBA contains the file number AND the block number.
>I also tried the following in another database which has got the >packages you said : >(is it okay to execute the below on any database which has got those packages >or is it to be done on the problem database only) > >sys.dbms_utility.data_block_address_block(537037017) = 166105 >sys.dbms_utility.data_block_address_file(537037017) = 128
IMO in 7.3 the file number part of the DBA is 8 bits (from 8.0 it is 10 bits). Therefore the correct file number is 32 (not 128).
>Is there any other way i can find out the file_id / object# from the >above ORA-600 (See ORA-600.ora-code.com) error. >The trace file too did not give me any pointer about the file# or object# .
DBMS_UTILITY (or manual decoding) is the way to go. Notice that if you have a corruption problem the DBA could be completely wrong and therefore point to a non existent block...
HTH Chris -- http://www.freelists.org/webpage/oracle-l
