Re: Oracle 7 Deletion Problem

The Peasant (prashant_at_cs.pitt.edu) wrote:
: 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 Thu Jul 21 1994 - 18:26:27 CEST