RE: cannot truncate a table

From: Babette Turner-Underwood <babette+oraclelist_at_pythian.com>
Date: Fri, 7 Jul 2000 14:17:14 -0400
Message-Id: <10551.111462@fatcity.com>

I had a similar problem recently. It was a table one of our users created that had 11,000+ extents. I tried to truncate it and it never happened. I then tried drop and voila!! (okay, it took a little while but you could see the data dictionary entries for the table being updated).

Just something else to consider. This was on Oracle 8.0

Babette

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Cydnee Williams
Sent: Wednesday, July 05, 2000 12:29 PM
To: Multiple recipients of list ORACLE-L Subject: RE: cannot truncate a table

Hey List, FYI. I was the owner of this table, had a problem to truncate but not drop. There were no priv or role issues, no corrupted datafiles. When I drop/recreated this table by using exp/imp on a different tablespace, still experienced the same Ora-942 error, I finally realized it was a public synonym problem. The DDL became a DL. The problem fixed by drop the synonym and recreated it with a different name. Received on Fri Jul 07 2000 - 13:17:14 CDT