[20211231]ORA-01418 specified index does not exist.txt
[20211231]ORA-01418 specified index does not exist.txt
--//維護索引改名發現報如下錯誤:
ORA-01418: specified index does not exist
$ oerr ora 01418
01418, 00000, "specified index does not exist"
// *Cause:
// *Action:
--//檢查表定義索引的名字定義如下,超過30個字元,在toad下版本可能比較老舊僅僅看到前面30個字元。
IF_YS_MZ_ZT01_SSLB_SSDM_ZTBH_1E7
--//僅僅顯示IF_YS_MZ_ZT01_SSLB_SSDM_ZTBH_1
1.環境:
xxxx1> @prxx
==============================
PORT_STRING : x86_64/Linux 2.4.xx
VERSION : 19.0.0.0.0
BANNER : Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
BANNER_FULL : Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.9.0.0.0
BANNER_LEGACY : Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
CON_ID : 0
PL/SQL procedure successfully completed.
--//只能在sqlplus下完成,以後運維注意,最好目前還是限制索引30個字元。避免不必要的麻煩。
2.改名:
xxxx1> alter index "PORTAL_HIS"."IF_YS_MZ_ZT01_SSLB_SSDM_ZTBH_1E7" rename to IF_YS_MZ_ZT01_SSLB_SSDM_ZTBH_X;
Index altered.
--//測試一下修改大於30個字元沒有問題,但是toad下顯示的是30個字元,再修改提示上面的資訊。
--//以後運維要注意這個細節。
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/267265/viewspace-2850347/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- The user specified as a definer ('wx_root'@'%') does not exist 解決方案
- mysql 1449 : The user specified as a definer ('root'@'%') does not exist 解決方法MySql
- java.lang.IllegalArgumentException: Path index does not start with a "/" charactJavaExceptionIndex
- z-index does not work in Internet Explorer with pdf in iframeIndex
- What is the difference between Mysql InnoDB B+ tree index and hash index? Why does MongoDB use B-tree?MySqlIndexMongoDB
- ValueError: Length of values (141) does not match length of index (4278)問題的解決ErrorIndex
- apache PHP 隱藏 index.php 報錯 No input file specified. 解決辦法ApachePHPIndex
- The specified JRE installation does not exist m2eclipse build Maven專案報錯的問題EclipseUIMaven
- mysql specified key was too long與Index column size too large. The maximum column size is 767 bytes.MySqlIndex
- No input file specified.
- apache 與 Nginx 隱藏 index.php 報錯 No input file specified. 解決辦法 設定偽靜態ApacheNginxIndexPHP
- [20211231]函式索引測試.txt函式索引
- KEEP INDEX | DROP INDEXIndex
- 執行gedit報No protocol specifiedProtocol
- No input file specified 解決方法
- Kill all sessions of a specified user nameSession
- ‘map’ does not name a type
- vector does not name a type
- asmcmd does not exist in directoryASM
- error :does not name a typeError
- rowid,index,INDEX FULL SCAN,INDEX FAST FULL SCAN|IndexAST
- 頁面報錯 No input file specified
- mongodb報錯:the limit must be specified as a number。MongoDBMIT
- INDEX UNIQUE SCAN,INDEX FULL SCAN和INDEX FAST FULL SCANIndexAST
- error: 'cout' does not name a type|Error
- How does a HashMap work in JAVAHashMapJava
- why does angular js rockAngularJS
- javax.media does not existJava
- How does one rename a database?Database
- What does "xargs grep" do?
- Clustered Index Scan and Clustered Index SeekIndex
- oracle hint之full,index,index_asc,index_desc,index_combile示例OracleIndex
- IndexIndex
- Index的掃描方式:index full scan/index fast full scanIndexAST
- rebuild index 和 recreate index (重新建立index) 的區別RebuildIndex
- [20211231]vim自動格式化sql語句.txtSQL
- pk 、unique index 和 index 區別Index
- global index & local index的區別Index