I don't know what the ORA-600 error is (have you called Oracle Support?),
but I know that, as you've defined the foreign key, you can't delete a row
in the parent table which has dependent rows in the child table, and since
you've made the parent and child table the same, you can't delete. Why on
earth would you define a constraint which says 2 columns must be identical
(key2, col3) ?
gzhu_at_calicotech.com wrote in message <7hqnli$hh6$1_at_nnrp1.deja.com>...
>Have you run into following problem ? Any idea on how to solve it
>(patch#, etc). This was running on Solaris 2.6.
>
>
>Oracle8 Release 8.0.5.0.0 - Production
>PL/SQL Release 8.0.5.0.0 - Production
>SQLWKS> create table ora600 (key1 int, key2 int, constraint ora600_PRIM
>primary key (key1, key2), col3 int, constraint ora600_FOR foreign key
>(key1, col3) references ora600 (key1, key2) );
>Statement processed.
>SQLWKS> create index ora600_IDX on ora600 (key1);
>Statement processed.
>SQLWKS> insert into ora600 (key1, key2) values (1, 2);
>1 row processed.
>SQLWKS> insert into ora600 (key1, key2, col3) values (2, 1, 1);
>1 row processed.
>SQLWKS> delete from ora600 where key1 = 1
> 2>
>ORA-00600: internal error code, arguments: [12700], [2686], [25166457],
>[0], [], [], [], []
>
>
>--== Sent via Deja.com http://www.deja.com/ ==--
>---Share what you know. Learn what you don't.---
Received on Tue May 18 1999 - 12:58:45 CDT
