Solved

Oracle: ORA-00600: internal error code, arguments: [ktsk_dba_to_hwm-1

Posted on 2010-11-22
7
1,281 Views
Last Modified: 2012-05-10
I am getting the following error: ORA-00600: internal error code, arguments: [ktsk_dba_to_hwm-1], [], [], [], [], [], [], []

It fails on statement
 execute immediate 'alter table  ACTION modify lob (MESSAGE) (shrink space)';

This job and this statement are currently running sucessfully on 17 other databases.    Any Ideas on how to fix the probelm and what caused it in the first place.

The Shrink space is running OK on other tables in the same Database.
 
0
Comment
Question by:fpkeegan
  • 4
  • 3
7 Comments
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
Comment Utility
It's a bug in oracle  search Oracle Support for Bug 9295217
0
 

Author Comment

by:fpkeegan
Comment Utility
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
 I can not find a link to this error for my version ..
0
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
log in to Oracle Support,  search "All Sources"  for 9295217 , you'll get 4 links,  3 of which apply to your error.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:fpkeegan
Comment Utility
If you are talking about the paid oracle Support web site. I do not have access to the site.  What is the URL of the free  support web site to find the information on this bug.
0
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
there isn't one.

sorry, you can only get information about this bug and patches for it through the Oracle Support site.
0
 

Author Closing Comment

by:fpkeegan
Comment Utility
Good job.. Could cut and pass the bug info into the answer. Which would have helped.
0
 
LVL 73

Expert Comment

by:sdstuber
Comment Utility
"Could cut and pass the bug info into the answer"

Sorry, that's not allowed per the oracle support agreements
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Article by: Swadhin
From the Oracle SQL Reference (http://download.oracle.com/docs/cd/B19306_01/server.102/b14200/queries006.htm) we are told that a join is a query that combines rows from two or more tables, views, or materialized views. This article provides a glimps…
Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now