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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00904: invalid identifierIDE
- exp匯出出現:ORA-00904: : invalid identifierIDE
- exp匯出出現:ORA-00904: "POLTYP": invalid identifierIDE
- 【LISTAGG】 ORA-00904: "WM_CONCAT": invalid identifier (DocIDE
- 關於merge時,出現的ORA-00904 invalid identifierIDE
- ORA-00904: "wm_concat":invalid identifier錯誤如何解決?IDE
- [20200312]ORA-00904 POLTYP invalid identifier.txtIDE
- [20210420]ORA-00904 REF invalid identifier 19c dba_obj_audit_opts.txtIDEOBJ
- Python 錯誤 SyntaxError: invalid character in identifierPythonErrorIDE
- [20211022]ORA-00904 REF invalid identifier 19c dba_obj_audit_opts(補充).txtIDEOBJ
- PostgreSQL DBA(80) - Object Identifier TypesSQLObjectIDE
- Oracle Custom Support Identifier(CSI)OracleIDE
- ORA-00904: : 識別符號無效符號
- Oracle identifiers :SID (System Identifier)OracleIDE
- JavaScript invalid 事件JavaScript事件
- exp匯出出現:ORA-00904::invalididentifierIDE
- 使用errorstack解決ORA-00904一例Error
- iOS 上架報錯 This bundle is invalid 或 Invalid Image PathiOS
- ORA-00904故障分析與解決一例
- oracle ORA-00904 poltyp 識別符號無效Oracle符號
- Remove Invalid Parentheses[難]REM
- 關於hibernate的 No row with the given identifier existsIDE
- Uncaught SyntaxError: Identifier 'Geometry' has already been declaredErrorIDE
- .NET Core Runtime IDentifier (RID) catalogIDE
- 【DataGuard】 TNS:could not resolve the connect identifier specifiedIDE
- stm32 use of undeclared identifier GPIO_InitTypeDefIDE
- StreamCorruptedException: invalid stream headerExceptionHeader
- Invalid double崩潰分析
- 重編譯 invalid 物件編譯物件
- How to compile Invalid Object?CompileObject
- ORA-00904/ORA-00942和ORACLE 大小寫區分Oracle
- oracle很奇怪的報ora-00904錯誤的討論Oracle
- Xcode This application's application-identifier entitlemeXCodeAPPIDE
- 判斷密文加密型別hash-identifier加密型別IDE
- SP2-0618: Cannot find the Session IdentifierSessionIDE
- The Mac is invalid. 為什麼?Mac
- 重編譯 invalid 物件(轉)編譯物件
- mybatis竟然報"Invalid value for getInt()"MyBatis