Re: Oracle 7 Deletion Problem

From: John Hogatt <j4hogatt_at_mccoy.srv.PacBell.COM>
Date: 11 Jul 1994 18:35:59 GMT
Message-ID: <2vs3ef$ms6_at_gw.PacBell.COM>


In article <1994Jul6.151315.26138_at_logibec.com>, sta_at_logibec.com writes:
|> Does someone have an idea why I cannot delete this table.
|> We encountered this problem twice, and Oracle Tech Support
|> suggested to restore the cold backup !!
|>
|> Oracle Product: Oracle 7.0.16 for SunOS 4.1.3
|>
|> SQL> desc tcmunicipality
|> Name Null? Type
|> ------------------------------- -------- ----
|> MUNICIPALITY NOT NULL CHAR(5)
|> MUNICIPALITYNAME NOT NULL VARCHAR2(30)
|> COUNTRY CHAR(4)
|> PROVINCE CHAR(2)
|> STATUS CHAR(1)
|> STATUSDATE 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], [], [], [], [], [], [], []
It looks like you're trying to delete from tcmunicipality, not to delete tcmunicipality. If that is true, then try the statement with the added keyword FROM, to be inserted between 'delete' and 'tcmunicipality'.

Good luck,

J <j4hogatt_at_mccoy.srv.pacbell.com> PacBell may not agree. Received on Mon Jul 11 1994 - 20:35:59 CEST

Original text of this message