Question:

I try to truncate a table and I get this:

QUOTE

ORA-00904: "DROP_SEGMENTS": invalid identifier

Can anybody suggest what the problem is and what I should do?

Cause: The post installation scripts were not run properly,so drop_segments column is missing from sys.mon_mods$ . One or more of these post installation scripts would add the new column to the database and if the script. is not run properly, it will cause an ORA-904 in the application later on.

Fix: Connect to the SQL session as SYS and issue the following:
SQL> desc sys.mon_mods$

If the drop_segments is missing then we are getting ORA-904.If this is the case,we can do one of these:

1.Shutdown the database- startup migrate and then run catpatch.sql and catalog.sql(the scripts that are needed to be run as a post-installarion process).

2.Add the drop_segments column using:
SQL> alter table sys.mon_mods$ add ( drop_segments number default 0 );

Then run $ORACLE_HOME/rdbms/admin/catalog.sql again.

ITPub博客

ORA-00904: "DROP_SEGMENTS": invalid identifier

最新文章