Solution : https://service.sap.com/sap/support/notes/1151509 (SAP Service marketplace login required)
Key words :
file# block# ts#--------------------------- 10 89179 3 10 89187 3 10 89195 3type#=3 <-- temporary segmentthe exception ora-600[kcbz_check_objd_typ_1], corrupted temp segments sql> select 'exec dbms_space_admin, file /oracle/<sid>/saptrace/background/sid_smon_xxxx, temp objects sql> select file#, identify blocks sql> select file#, 10g startup migrate fails withora-00600, sql> select 'exec dbms_space_admin, corrupt temp segments involved, cleaning temp segments event=, sysdba sql> startup migrate5
Related Notes :
| 23345 | Consistency check of ORACLE database |