ORACLE INTERNAL ERROR-600 URGENT PL HELP

From: <amohamme_at_my-dejanews.com>
Date: Tue, 18 May 1999 02:29:40 GMT
Message-ID: <7hqjaj$eg4$1@nnrp1.deja.com>

When dropping and recreating primary constraints on one particular table I got the Ora-600 error. Now I am not able to even drop the table. I doesn't let me select from it. If I do a select count(*) from table_name it works, but if I give select * from table_name it gives error ORA-600 the arguments are [4149],[36],[35].

I called Oracle support they said another process had a n exclusive lock on the table that's why, we killed the process but when I issue selct count(*) it works but selct * from does not work.

If I try to drop the table or the tablespace I get the same ORA-600 error.

Pl. help !

Thanks !

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Mon May 17 1999 - 21:29:40 CDT