Re: ORA-00604: error occurred at recursive SQL level 1 ORA-02264: name already used by an existing constraint
- From: Taral Desai <taral.desai@xxxxxxxxx>
- To: orasnita@xxxxxxxxx
- Date: Thu, 23 Sep 2010 09:32:03 -0500
There could be bug but they don't say
*ORA-00600 [16500] [kqdcru] When Running A Purge Command [ID 470322.1]*
*
*
*Basically it says*
*
*
*1. login as sysdba and try to purge recyclebin*
*2. If #1 not work then*
*
*
*Change the NLS_SORT to BINARY before running the Purge command.
SQL> ALTER SESSION SET NLS_SORT = BINARY;
*
2010/9/23 Octavian Rasnita <orasnita@xxxxxxxxx>
> Hi,
>
> I found a strange problem in a database under Oracle Database 11g Release
> 11.2.0.1.0 - 64bit Production.
> I searched a lot on the net but I couldn't find a solution for it.
>
> After I create a table and I try to drop it, I receive the following error
> message:
>
> ORA-00604: error occurred at recursive SQL level 1
> ORA-02264: name already used by an existing constraint
>
> The table has the structure as below. It also contains more other columns
> but they don't have any constraint defined and I don't know why such an
> error appears after drop table.
>
> I found some messages on the net telling that this issue appears because of
> recyclebin (because the constraints get dupplicated in recyclebin) and the
> suggestion to use `purge recyclebin` but when I give this command it gives
> the following error which is even more strange:
>
> ORA-00600: internal error code, arguments: [16500], [kqdcru], [D], [2],
> [91],
> [BIN$jMPhYuTGVJvgQDIKGRwO+w==$0], [], [], [], [], [], []
>
> I have also tried to do `delete from recyclebin` but it gives the error
> "ORA-01031: insufficient privileges"
>
> I was able to delete those tables by loging with the sys account as sysdba,
> but I don't know why I can't drop a table after I created it using my
> username.
>
> Here is the table structure. I verified and the constraints used in this
> table are not used somewhere else.
> The strange thing is that I succeeded to drop the table first time using my
> username, but after re-creating it, I wasn't able to drop it anymore,
> because it gave that error.
>
> Please help!
>
> create table bilant_fonduri(
> id integer constraint bilant_fonduri_pk primary key,
> symbol varchar2(20) constraint bilant_fonduri_symbol_nn not null,
> last_update date default sysdate,
> year integer constraint bilant_fonduri_year_nn not null,
> trim integer constraint bilant_fonduri_trim_nn not null constraint
> bilant_fonduri_trim_c check(trim in('1','2','3','4')),
> data_publicare date,
> valoare_nominala_emitere number(12,4),
> valoare_nominala_publicare number(12,4),
> nr_actiuni_emitere integer,
> nr_actiuni_publicare integer,
> pret_emitere number(12,4),
> pret_publicare number(12,4),
> active number(1) default 0,
> constraint bilant_fonduri_sym_y_t_u unique(symbol, year, trim),
> ...
> );
>
>
> Thank you.
>
> --Octavian
>
--
Thanks & Regards,
Taral Desai
Other related posts:
