Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Problem with Truncate Table
On 28 Feb, 15:23, "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 did this start happening? Also, can you post a copy of your SQL*Plus session to show exactly what you're doing, please? Received on Wed Feb 28 2007 - 10:50:50 CST