Hi
I got this error while importing a dumpfile to database.
Please help me to solve this error.
I create database manually.
Run scripts - cattalog.sql, catproc.sql,pupbls.sql
===========================
. importing MHUBADMIN's objects into MHUBADMIN
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"ctxsys.driimp.create_index('ORG_TEXT','ORGANIZATION',USER,"
"'ORG_ID','2','ORG_NAME','1',"
"'250','6','8130','7',"
"NULL, NULL, NULL, 0,NULL );"
""
""
"ctxsys.driimp.set_object('DATASTORE','DIRECT_DATASTORE',0);"
""
"ctxsys.driimp.set_object('DATATYPE','CHAR_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','BASIC_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_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 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:
regards
Mathew