|
IMP-00017: 由于 ORACLE 错误6550,以下的语句失败
"BEGIN "
"ctxsys.driimp.create_index('MLTEXT_DOC','MULTILINE_TEXT',USER,"
"'','1','DATA','8',"
"'0','13209','8130','14546',"
"NULL, NULL, NULL, 0);"
""
""
"ctxsys.driimp.set_object('DATASTORE','DIRECT_DATASTORE',0);"
""
"ctxsys.driimp.set_object('DATATYPE','LONG_DATATYPE',0);"
""
"ctxsys.driimp.set_object('DATAX','SYNCH_DATAX',0);"
""
"ctxsys.driimp.set_object('FILTER','NULL_FILTER',0);"
""
"ctxsys.driimp.set_object('SECTION_GROUP','NULL_SECTION_GROUP',0);"
""
"ctxsys.driimp.set_object('LEXER','CHINESE_VGRAM_LEXER',0);"
""
"ctxsys.driimp.set_object('WORDLIST','BASIC_WORDLIST',2);"
"ctxsys.driimp.set_value('STEMMER','1');"
"ctxsys.driimp.set_value('FUZZY_MATCH','1');"
""
"ctxsys.driimp.set_object('STOPLIST','BASIC_STOPLIST',76);"
"ctxsys.driimp.set_value('STOP_WORD','Corp');"
"ctxsys.driimp.set_value('STOP_WORD','Mr');"
"ctxsys.driimp.set_value('STOP_WORD','Mrs');"
"ctxsys.driimp.set_value('STOP_WORD','Ms');"
"ctxsys.driimp.set_value('STOP_WORD','Mz');"
"ctxsys.driimp.set_value('STOP_WORD','a');"
"ctxsys.driimp.set_value('STOP_WORD','about');"
"ctxsys.driimp.set_value('STOP_WORD','after');"
"ctxsys.driimp.set_value('STOP_WORD','all');"
"ctxsys.driimp.set_value('STOP_WORD','also');"
"ctxsys.driimp.set_value('STOP_WORD','an');"
"ctxsys.driimp.set_value('STOP_WORD','and');"
"ctxsys.driimp.set_value('STOP_WORD','any');"
"ctxsys.driimp.set_value('STOP_WORD','are');"
"ctxsys.driimp.set_value('STOP_WORD','as');"
"ctxsys.driimp.set_value('STOP_WORD','at');"
"ctxsys.driimp.set_value('STOP_WORD','be');"
"ctxsys.driimp.set_value('STOP_WORD','because');"
"ctxsys.driimp.set_value('STOP_WORD','been');"
"ctxsys.driimp.set_value('STOP_WORD','but');"
"ctxsys.driimp.set_value('STOP_WORD','by');"
"ctxsys.driimp.set_value('STOP_WORD','can');"
"ctxsys.driimp.set_value('STOP_WORD','co');"
"ctxsys.driimp.set_value('STOP_WORD','could');"
"ctxsys.driimp.set_value('STOP_WORD','for');"
"ctxsys.driimp.set_value('STOP_WORD','from');"
"ctxsys.driimp.set_value('STOP_WORD','had');"
"ctxsys.driimp.set_value('STOP_WORD','has');"
"ctxsys.driimp.set_value('STOP_WORD','have');"
"ctxsys.driimp.set_value('STOP_WORD','he');"
"ctxsys.driimp.set_value('STOP_WORD','her');"
"ctxsys.driimp.set_value('STOP_WORD','his');"
"ctxsys.driimp.set_value('STOP_WORD','if');"
"ctxsys.driimp.set_value('STOP_WORD','in');"
"ctxsys.driimp.set_value('STOP_WORD','inc');"
"ctxsys.driimp.set_value('STOP_WORD','into');"
"ctxsys.driimp.set_value('STOP_WORD','is');"
"ctxsys.driimp.set_value('STOP_WORD','it');"
"ctxsys.driimp.set_value('STOP_WORD','its');"
"ctxsys.driimp.set_value('STOP_WORD','last');"
"ctxsys.driimp.set_value('STOP_WORD','more');"
"ctxsys.driimp.set_value('STOP_WORD','most');"
"ctxsys.driimp.set_value('STOP_WORD','no');"
"ctxsys.driimp.set_value('STOP_WORD','not');"
"ctxsys.driimp.set_value('STOP_WORD','of');"
"ctxsys.driimp.set_value('STOP_WORD','on');"
"ctxsys.driimp.set_value('STOP_WORD','one');"
"ctxsys.driimp.set_value('STOP_WORD','only');"
"ctxsys.driimp.set_value('STOP_WORD','or');"
"ctxsys.driimp.set_value('STOP_WORD','other');"
"ctxsys.driimp.set_value('STOP_WORD','out');"
"ctxsys.driimp.set_value('STOP_WORD','over');"
"ctxsys.driimp.set_value('STOP_WORD','s');"
"ctxsys.driimp.set_value('STOP_WORD','says');"
"ctxsys.driimp.set_value('STOP_WORD','she');"
"ctxsys.driimp.set_value('STOP_WORD','so');"
"ctxsys.driimp.set_value('STOP_WORD','some');"
"ctxsys.driimp.set_value('STOP_WORD','such');"
"ctxsys.driimp.set_value('STOP_WORD','than');"
"ctxsys.driimp.set_value('STOP_WORD','that');"
"ctxsys.driimp.set_value('STOP_WORD','the');"
"ctxsys.driimp.set_value('STOP_WORD','their');"
"ctxsys.driimp.set_value('STOP_WORD','there');"
"ctxsys.driimp.set_value('STOP_WORD','they');"
""
"ctxsys.driimp.set_value('STOP_WORD','this');"
"ctxsys.driimp.set_value('STOP_WORD','to');"
"ctxsys.driimp.set_value('STOP_WORD','up');"
"ctxsys.driimp.set_value('STOP_WORD','was');"
"ctxsys.driimp.set_value('STOP_WORD','we');"
"ctxsys.driimp.set_value('STOP_WORD','were');"
"ctxsys.driimp.set_value('STOP_WORD','when');"
"ctxsys.driimp.set_value('STOP_WORD','which');"
"ctxsys.driimp.set_value('STOP_WORD','who');"
"ctxsys.driimp.set_value('STOP_WORD','will');"
"ctxsys.driimp.set_value('STOP_WORD','with');"
"ctxsys.driimp.set_value('STOP_WORD','would');"
""
"ctxsys.driimp.set_object('STORAGE','BASIC_STORAGE',2);"
"ctxsys.driimp.set_value('R_TABLE_CLAUSE','lob (data) store as (cache)');"
"ctxsys.driimp.set_value('I_INDEX_CLAUSE','compress 2');"
""
"commit;"
"COMMIT; END;"
IMP-00003: ORACLE 错误6550出现
ORA-06550: 第 2 行, 第 1 列:
PLS-00201: 必须说明标识符 'CTXSYS.DRIIMP'
ORA-06550: 第 2 行, 第 1 列:
PL/SQL: Statement ignored
ORA-06550: 第 8 行, 第 1 列:
PLS-00201: 必须说明标识符 'CTXSYS.DRIIMP'
ORA-06550: 第 8 行, 第 1 列:
PL/SQL: Statement ignored
ORA-06550: 第 10 行, 第 1 列:
PLS-00201: 必须说明标识符 'CTXSYS.DRIIMP'
ORA-06550: 第 10 行, 第 1 列:
PL/SQL: Statement ignored
ORA-06550: 第 12 行, 第 1 列:
PLS-00201: 必须说明标识符 'CTXSYS.DRIIMP'
ORA-06550: 第 12 行, 第 1 列:
PL/SQL: Statement ign
IMP-00088: 导入索引MLTEXT_DOC的元数据时出现错误,将跳过索引创建
准备启用约束条件...
成功终止导入,但出现警告。
登陆Clearquest客户端(win),双击Public Queries列表中已建立的项目文件夹下的Query目录,报错:
sdlkfj2ERROR!Multiline text search is currently disabled.You must remove the text filter from the query before running it.Contact your dba to resolve this problem. Possible causes are:
1.ConText/InterMedia Text server is not running.
2.Required index and/or policy is not properly created in the database.
Refer to 'setup_cq_ora_user.sql'and'setup_cq_intermedia.sql'for Oracle 8i or'setup_cq_ctx_policy.sql'for 7.3 and 8.0 in ClearQuest install directory.
以前用同样的方法导入数据库一直没有出现过这个问题,但最近试了几次都报这样的错误,请高手指点迷津,先在这里谢过了。 |
|