Re: Problem with Truncate Table

From: <fitzjarrell_at_cox.net>
Date: 28 Feb 2007 08:47:37 -0800
Message-ID: <1172681257.002881.233880@j27g2000cwj.googlegroups.com>

On Feb 28, 9:23 am, "BGT" <bgt0..._at_optonline.net> wrote:
> I am no longer able to truncate tables in this 9.2.0.6.0 database.
> When I do a "truncate table "tablename" drop storage" I get ORA-00904
> "DROP SEGMENTS" INVALID IDENTIFIER.
>
> I've tried this on multiple tables as the schema owner and a SYSDBA
> user with the same results. Any idea what is happening?
>
> Thanks
> Barry

When COULD you complete this? What has occurred since the last successful 'truncate table' and now? You don't provide enough information to answer your question.

David Fitzjarrell Received on Wed Feb 28 2007 - 10:47:37 CST