Truncate table problem

From: Kim Johnson <kim_at_medicus.com>
Date: Fri, 21 Jan 1994 19:31:12 GMT
Message-ID: <1994Jan21.193112.26010_at_medicus.com>

We've recently encountered a problem which seems related to using the "truncate table" command. We have a short SQL script which truncates about 10 tables, then commits and exits. Afterwards, when trying to access one of the tables, users are able to insert rows, but not update them (our application first creates nearly empty rows, and then updates them). We get error ORA-00600. Unfortunately I didn't try a "validate structure" before dropping and re-creating the table, so I'm not certain that the table was corrupted, but that's what seems to have happened. We're running Oracle Server 7.0.12 under SunOS 4.1.3.

Has anyone else experienced any problems with this command, or am I using it as a scapegoat for the real culprit?

---

Kim Johnson
Software Engineer
Medicus Systems, Corp.
Alameda, CA Received on Fri Jan 21 1994 - 20:31:12 CET