table MGMT_STRING_METRIC_HISTORY corrupted - HOW CAN I DROP IT ?

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    

--

http://www.freelists.org/webpage/oracle-l Received on Wed May 25 2011 - 05:28:41 CDT