IMP-00088: Problem importing metadata for index xxx. Index creation will be skipped
来源:互联网 发布:网页展示 excel数据 编辑:程序博客网 时间:2024/06/05 07:56
错误信息:IMP-00088: Problem importing metadata for index WXSW_CPL_INDEX. Index creation will be skipped
执行SQL: select dbms_metadata.get_ddl('INDEX','WXSW_CTS_TITLE_INDEX','ITTEST') from dual;
结果:
CREATE INDEX "ITTEST"."WXSW_CTS_TITLE_INDEX" ON "ITTEST"."DN_CSL_RCP" ("DN_CSL_TITLE")
INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('DATASTORE CTXSYS.DIRECT_DATASTORE
LEXER wtt0603.CNLEX WORDLIST wtt0603.MYWORDLIST')
=========================
select object_name,object_type from dba_objects where object_name like '%DRIIMP%';
OBJECT_NAME OBJECT_TYPE CREATED
DRIIMP PACKAGE 2005/08/30 14:26:30
DRIIMP PACKAGE BODY 2005/08/30 14:26:43
select object_name,object_type,created from dba_objects where object_name like '%DRIIMP%';
=================================
结论:创建的9个全文索引都出问题。
步骤:
1. 确认是否有CTXSYS用户:
SQL> select username from all_users where username like '%CTXSYS%';
2.
- IMP-00088: Problem importing metadata for index xxx. Index creation will be skipped
- Mongo Index creation by Java
- ERROR: index 'xxx': sql_connect: Access denied for user 'xxx'@'localhost'
- 调用executeUpdate,屏蔽Could not find index for XXX信息
- FutureWarning: in the future, boolean array-likes will be handled as a boolean array index
- xxx will be initialized after
- Index
- Index
- index
- index
- index
- index
- index
- Index
- index
- index
- index()
- Index
- Android通过Servlet连接阿里云服务器的mysql <一>(servlet编程)
- 按钮左边是圆角,右边是方角
- 技术团队的情绪与效率
- 优秀Java程序员的编程风格
- win7下启动nexus报错:The nexus-webapp service was launched, but failed to start解决
- IMP-00088: Problem importing metadata for index xxx. Index creation will be skipped
- Linux环境下如何实用ab命令实现接口的性能测试
- 【大型网站技术实践】初级篇:借助Nginx搭建反向代理服务器
- jmeter之监听器
- 程序员养成指南
- VB.net视频总结二
- mysql 主从配置(master/slave)
- java.lang包概述
- JMeter 聚合报告之90% Line参数说明