Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00600, Errror while creating index
ORA-00600, Errror while creating index [message #248935] Mon, 02 July 2007 14:56 Go to next message
harry07
Messages: 61
Registered: June 2007
Location: now york
Member
I am trying to create index on two fields and both are Timestamp type fileds.

SQL> desc channels_viewed
Name Null? Type
----------------------------------------- -------- ----------------------------
USER_ID LONG
ID NOT NULL NUMBER
SESSION_ID VARCHAR2(128)
STREAM_ID NUMBER
CHANNEL_ID VARCHAR2(64)
VIEW_START TIMESTAMP(6)
VIEW_STOP TIMESTAMP(6)


create index idx_cv_view_stop
on channels_viewed (to_date(to_char(view_stop,'mm/dd/yyyy'),'mm/dd/yyyy'));
Index created.

SQL> create index idx_cv_view_start
2 on channels_viewed (to_date(to_char(view_start,'mm/dd/yyyy'),'mm/dd/yyyy'));
on channels_viewed (to_date(to_char(view_start,'mm/dd/yyyy'),'mm/dd/yyyy'))
*
ERROR at line 2:
ORA-00600: internal error code, arguments: [x-hp-kksfbc], [], [], [], [], [],
[], []

SQL> drop index idx_cv_view_stop;

Index dropped.

SQL> create index idx_cv_view_start_stop
2 on channels_viewed (to_date(to_char(view_start,'mm/dd/yyyy'),'mm/dd/yyyy'),to_date(to_char(view
_stop,'mm/dd/yyyy'),'mm/dd/yyyy'));

Index created.

I am bale to create index on only one field, even that is not working when I run my query. I tried to create composite index, but again my query is not working. When I run my query I am getting the same error as above.

Re: ORA-00600, Errror while creating index [message #248941 is a reply to message #248935] Mon, 02 July 2007 15:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-600 = Oracle bug => search on Metalink and/or call Oracle support.

Regards
Michel
Re: ORA-00600, Errror while creating index [message #249003 is a reply to message #248941] Tue, 03 July 2007 01:22 Go to previous message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
It works on my Oracle Database 10g Express Edition Release 10.2.0.1.0 (Windows XP) and on one of our test boxes Oracle9i Release 9.2.0.3.0 (IBM RS/6000). What OS and Oracle version?

But in the end Michel is right: ORA-600 is an internal error. If you encounter those, it's time you used your support contract. Connect to Oracle MetaLink and search for the ORA-600 (there's a lookup utility at metalink) and if you can't find anything relevant open a Service Reauest (a.k.a. TAR).

MHE
Previous Topic: Unable to get a single row per result
Next Topic: question on views
Goto Forum:
  


Current Time: Sun Dec 04 23:05:18 CST 2016

Total time taken to generate the page: 0.05408 seconds