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