ORA-00904: "DROP_SEGMENTS": invalid identifier
Question:
I try to truncate a table and I get this:
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [20200312]ORA-00904 POLTYP invalid identifier.txtIDE
- 【LISTAGG】 ORA-00904: "WM_CONCAT": invalid identifier (DocIDE
- ORA-00904: "wm_concat":invalid identifier錯誤如何解決?IDE
- [20210420]ORA-00904 REF invalid identifier 19c dba_obj_audit_opts.txtIDEOBJ
- [20211022]ORA-00904 REF invalid identifier 19c dba_obj_audit_opts(補充).txtIDEOBJ
- Python 錯誤 SyntaxError: invalid character in identifierPythonErrorIDE
- PostgreSQL DBA(80) - Object Identifier TypesSQLObjectIDE
- JavaScript invalid 事件JavaScript事件
- found an invalid color
- Uncaught SyntaxError: Identifier 'Geometry' has already been declaredErrorIDE
- 關於hibernate的 No row with the given identifier existsIDE
- [20210114]理解DBMS_SESSION.set_identifier.txtSessionIDE
- stm32 use of undeclared identifier GPIO_InitTypeDefIDE
- StreamCorruptedException: invalid stream headerExceptionHeader
- Invalid time zone indicator ‘ ‘Indicator
- python: invalid value encountered in divide以及invalid value encountered in double_scalars報錯PythonIDE
- OSError: [Errno 22] Invalid argumentError
- [Error Code: 904, SQL State: 42000] ORA-00904 : 識別符號無效ErrorSQL符號
- SQLLoader ORA-01722 invalid numberSQL
- The Mac is invalid. 為什麼?Mac
- 重編譯 invalid 物件(轉)編譯物件
- ORA-00130: invalid listener address
- mybatis竟然報"Invalid value for getInt()"MyBatis
- Elasticsearch 6 建立索引報錯 invalid_index_name_exception Invalid index name [testDemo], must be lowercaseElasticsearch索引IndexException
- Oracle案例09——ORA-12154: TNS:could not resolve the connect identifier specifiedOracleIDE
- 識別雜湊演算法型別hash-identifier演算法型別IDE
- std::sort 錯誤"Expression : invalid operator <"Express
- SQLSTATE [22007]: Invalid datetime format: 1292 IncorrectSQLORM
- 匯入 appium 報 SyntaxError: invalid syntaxAPPError
- React報錯之Element type is invalidReact
- 有Oracle support identifier的沒?幫下載兩個補丁OracleIDE
- 報錯:ORA-00603、ORA-01092、ORA-00704, ORA-00604, ORA-00904
- 使用yum報錯Your license is invalid.
- invalid stream header: EFBFBDEF 問題解決Header
- jQuery 事件函式傳參異常identifier starts immediately after numeric literaljQuery事件函式IDE
- 表結構遷移檔案Identifier name 'xxxxxx' is too long解決IDE
- Django報錯ValueError: invalid literal for int() with base 10:DjangoError
- xcrun: error: invalid active developer path (/Library/Developer/CommandLineTools)ErrorDeveloper
- invalid conversion from ‘LRUCache*‘ to ‘int‘ [-fpermissive] /new的使用