Re: Problem with Truncate Table

On Feb 28, 7: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

Well, there was a bug in an earlier version, maybe somewhere along the line you ran the wrong catalog.sql or got an old sql.bsq.

as sys,
SQL> desc mon_mods$

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 OBJ#                                               NUMBER
 INSERTS                                            NUMBER
 UPDATES                                            NUMBER
 DELETES                                            NUMBER
 TIMESTAMP                                          DATE
 FLAGS                                              NUMBER
 DROP_SEGMENTS                                      NUMBER

If you don't have a field named drop_segments, you have this problem (which could potentially be a quite serious patching goof). Check sql.bsq to be sure it has a create statement that matches this table. Then try running catalog.sql.

jg

--
@home.com is bogus.
Are they still using Sybase?  http://www.kstp.com/article/stories/S33513.shtml?cat=1