|
|
IOTN :: Field Book :: ORACLE 
|
|
create ctxsys [ 9i,10g ]
|
|
최길호
[LIST]
|
2011-04-16 20:25:33, 조회 : 33,835 |
i## imp error
IMP-00017: following statement failed with ORACLE error 6550:
IMP-00003: ORACLE error 6550 encountered
ORA-06550: line 2, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 8, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 8, column 1:
PL/SQL: Statement ignored
ORA-06550: line 10, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-06550: line 10, column 1:
PL/SQL: Statement ignored
ORA-06550: line 12, column 1:
PLS-00201: identifier 'CTXSYS.DRIIMP' must be declared
ORA-065
IMP-00088: Problem importing metadata for index ARTICLE_VALUE_IDX. Index creation will be skipped
Import terminated successfully with warnings.
## SQL> error
exec ctxsys.driimp.create_index('ARTICLE_VALUE_IDX','ARTICLE_CONTENT_TBLC',USER,'ARTID,MODSERNO','1','VALUE','112','0','98224','8130','98225',NULL, NULL, NULL, 0,NULL );
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-52204: error while registrating index
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.DRIIMP", line 100
ORA-06512: at line 1
-- 조치
-- 9i
conn /as sysdba
create tablespace drsys datafile
'/oracle/product/9.2/oradata/DB/drsys01.dbf'
size 20m autoextend on next 20m maxsize unlimited;
@?/ctx/admin/dr0csys ctxsys drsys temp
conn ctxsys/ctxsys
@?/ctx/admin/dr0inst ?/ctx/lib/libctxx9.so
@?/ctx/admin/defaults/drdefus.sql
grant execute on ctxsys.ctx_ddl to public;
grant CTXAPP to user_name;
col version format a14
col comp_name format a30
select COMP_NAME,VERSION,STATUS from dba_registry;
-- test
BEGIN
ctxsys.driimp.create_index('ARTICLE_VALUE_IDX','ARTICLE_CONTENT_TBLC',USER,
'ARTID,MODSERNO','1','VALUE','112',
'0','98224','8130','98225',
NULL, NULL, NULL, 0,NULL );
ctxsys.driimp.set_object('DATASTORE','DIRECT_DATASTORE',0);
ctxsys.driimp.set_object('DATATYPE','LOB_DATATYPE',0);
ctxsys.driimp.set_object('DATAX','SYNCH_DATAX',0);
ctxsys.driimp.set_object('FILTER','NULL_FILTER',0);
ctxsys.driimp.set_object('SECTION_GROUP','AUTO_SECTION_GROUP',0);
ctxsys.driimp.set_object('LEXER','BASIC_LEXER',0);
ctxsys.driimp.set_object('WORDLIST','BASIC_WORDLIST',2);
ctxsys.driimp.set_value('STEMMER','8');
ctxsys.driimp.set_value('FUZZY_MATCH','3');
ctxsys.driimp.set_object('STOPLIST','BASIC_STOPLIST',0);
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;
/
PL/SQL procedure successfully completed.
-- 출처
http://www.dbatools.net/experience/oracle_context_index_install.html |
3.235.60.197
|
|
|
|
Copyright 1999-2023 Zeroboard / skin by 최길호(gilho.kr@gmail.com)
|
|
|
12/01 