table MGMT_STRING_METRIC_HISTORY corrupted - HOW CAN I DROP IT ?
- From: "Kedryna Marcin-HKP384" <MarcinK@xxxxxxxxxxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 25 May 2011 11:28:41 +0100
Hi, Oracle 10.0.0.2 I have the problem with table MGMT_STRING_METRIC_HISTORY being corrupted. There are a lot of .trc files showing all the time because inserts into this table cannot be done. Some trace: ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [ktspgfb-1], , , , , , ,  Current SQL statement for this session: INSERT INTO MGMT_STRING_METRIC_HISTORY (TARGET_GUID, KEY_VALUE, COLLECTION_TIMESTAMP, METRIC_GUID, STRING_VALUE) VALUES (:B1 , :B2 , :B3 , :B4 , :B5 ) ----- PL/SQL Call Stack ----- object line object handle number name 319191BC 33 SYSMAN.RAW_METRICS_AFTER_INSERT 3192F918 364 package body SYSMAN.EMD_SCHEMA 31A23228 952 package body SYSMAN.EMD_COLLECTION 31A45FAC 695 package body SYSMAN.EMD_MAINTENANCE Can I safely drop and re-create the table ? When I try to drop it i get the error: ORA-00054: resource busy and acquire with NOWAIT specified because oracle is probably trying to do something with this table at the same time. Is there a way to drop it safely ? There is no backup that I could recover from. Another thing is that I do not have the access to the database, so I need to send the script to the customer and he needs to run it - therefore I cannot try it and re-try it if it fails. Thank you for your help, Marcin
Other related posts:
- » table MGMT_STRING_METRIC_HISTORY corrupted - HOW CAN I DROP IT ? - Kedryna Marcin-HKP384