ORA-00904: "DROP_SEGMENTS": invalid identifier

tolywang發表於2009-05-19

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?

Answer: by

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部落格 ” ,連結:http://blog.itpub.net/35489/viewspace-600426/,如需轉載,請註明出處,否則將追究法律責任。

相關文章