Re: Oracle 7 Deletion Problem
From: The Peasant <prashant_at_cs.pitt.edu>
Date: 13 Jul 1994 16:37:34 GMT
Message-ID: <30158e$q06_at_toads.pgh.pa.us>
: > |>
: > |> SQL> delete tcmunicipality where MUNICIPALITYNAME like 'Mun%';
: > |> delete tcmunicipality where MUNICIPALITYNAME like 'Mun%'
: > |> *
: > |> ERROR at line 1:
: > |> ORA-00600: internal error code, arguments: [12838], [], [], [], [], [], [],
: > []
Date: 13 Jul 1994 16:37:34 GMT
Message-ID: <30158e$q06_at_toads.pgh.pa.us>
Tony Jambu (aaj_at_cmutual.com.au) wrote:
B
: . DATE
: > |>
: > |> SQL> delete tcmunicipality where MUNICIPALITYNAME like 'Mun%';
: > |> delete tcmunicipality where MUNICIPALITYNAME like 'Mun%'
: > |> *
: > |> ERROR at line 1:
: > |> ORA-00600: internal error code, arguments: [12838], [], [], [], [], [], [],
: > []
One thing you could try is check under the USER_CONSTRAINTS to see if you have set any constraints on this table. If a primary key constraint has been set Disable the primary Key constraint then go ahead and drop this constraint. Then try to drop it. It should work. I do not know your version of Database but there is a similar problem in 7.0.13.
: -- : _____ ________ / ____ |Tony Jambu, Database Administrator : /_ _ /_ __ / |Colonial Mutual Invest Mgmt,Aust (ACN004021809) : /(_)/ )(_/ \_/(///(/_)/_( |EMAIL: TJambu_at_cmutual.com.au : \_______/ |PHONE: +61-3-2831639 FAX: +61-3-2831090
-- **************************************** ** Prashanth The Peasant ** ** prashant_at_cs.pitt.edu ** ** _ ** ** ()__() (_) ** ** ( oo ) ,-' ** ** /^`\%'^\ / ** ** (/( . )\) ** ** Q/--\Q ** ** ** ** Life's complex, It has real and ** ** imaginary parts. ** ****************************************Received on Wed Jul 13 1994 - 18:37:34 CEST