Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

import error

859486Mar 5 2012 — edited Mar 6 2012

i am importing several export dumps one by one in same schema which consists of same table name

i am not getting rows inserted

how could i resolve following issue

can i remove update_sos_log?

pls suggest

thanks

ORA-04098: trigger 'OSODLOGS.UPDATE_OS_LOG'

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning option

Export file created by EXPORT:V10.02.01 via conventional path
import done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
import server uses AL32UTF8 character set (possible charset conversion)
. importing OSODLOGS's objects into OSODLOGS
. importing OSODLOGS's objects into OSODLOGS
. . importing table "OS_ONDEMAND_LOGS"
IMP-00058: ORACLE error 4098 encountered
ORA-04098: trigger 'OSODLOGS.UPDATE_OS_LOG' is invalid and failed re-validation
IMP-00017: following statement failed with ORACLE error 6550:
"BEGIN "
"ctxsys.driimp.create_index('LOG_MSG_OTS','OS_ONDEMAND_LOGS',USER,"
"'','1','LOG_MSG','1',"
"'2083','7748403','8130','7748404',"
"NULL, NULL, NULL, 0,NULL, NULL, NULL, NULL, 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',114);"
"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','a');"
"ctxsys.driimp.set_value('STOP_WORD','all');"
"ctxsys.driimp.set_value('STOP_WORD','almost');"
"ctxsys.driimp.set_value('STOP_WORD','also');"
"ctxsys.driimp.set_value('STOP_WORD','although');"
"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','both');"
"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','could');"
"ctxsys.driimp.set_value('STOP_WORD','d');"
"ctxsys.driimp.set_value('STOP_WORD','did');"
"ctxsys.driimp.set_value('STOP_WORD','do');"
"ctxsys.driimp.set_value('STOP_WORD','does');"
"ctxsys.driimp.set_value('STOP_WORD','either');"
"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','having');"
"ctxsys.driimp.set_value('STOP_WORD','he');"
"ctxsys.driimp.set_value('STOP_WORD','her');"
"ctxsys.driimp.set_value('STOP_WORD','here');"
"ctxsys.driimp.set_value('STOP_WORD','hers');"
"ctxsys.driimp.set_value('STOP_WORD','him');"
"ctxsys.driimp.set_value('STOP_WORD','his');"
"ctxsys.driimp.set_value('STOP_WORD','how');"
"ctxsys.driimp.set_value('STOP_WORD','however');"
"ctxsys.driimp.set_value('STOP_WORD','i');"
"ctxsys.driimp.set_value('STOP_WORD','if');"
"ctxsys.driimp.set_value('STOP_WORD','in');"
"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','just');"
"ctxsys.driimp.set_value('STOP_WORD','ll');"
"ctxsys.driimp.set_value('STOP_WORD','me');"
"ctxsys.driimp.set_value('STOP_WORD','might');"
"ctxsys.driimp.set_value('STOP_WORD','my');"
"ctxsys.driimp.set_value('STOP_WORD','no');"
"ctxsys.driimp.set_value('STOP_WORD','non');"
"ctxsys.driimp.set_value('STOP_WORD','nor');"
"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','onto');"
"ctxsys.driimp.set_value('STOP_WORD','or');"
""
"ctxsys.driimp.set_value('STOP_WORD','our');"
"ctxsys.driimp.set_value('STOP_WORD','ours');"
"ctxsys.driimp.set_value('STOP_WORD','s');"
"ctxsys.driimp.set_value('STOP_WORD','shall');"
"ctxsys.driimp.set_value('STOP_WORD','she');"
"ctxsys.driimp.set_value('STOP_WORD','should');"
"ctxsys.driimp.set_value('STOP_WORD','since');"
"ctxsys.driimp.set_value('STOP_WORD','so');"
"ctxsys.driimp.set_value('STOP_WORD','some');"
"ctxsys.driimp.set_value('STOP_WORD','still');"
"ctxsys.driimp.set_value('STOP_WORD','such');"
"ctxsys.driimp.set_value('STOP_WORD','t');"
"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','them');"
"ctxsys.driimp.set_value('STOP_WORD','then');"
"ctxsys.driimp.set_value('STOP_WORD','there');"
"ctxsys.driimp.set_value('STOP_WORD','therefore');"
"ctxsys.driimp.set_value('STOP_WORD','these');"
"ctxsys.driimp.set_value('STOP_WORD','they');"
"ctxsys.driimp.set_value('STOP_WORD','this');"
"ctxsys.driimp.set_value('STOP_WORD','those');"
"ctxsys.driimp.set_value('STOP_WORD','though');"
"ctxsys.driimp.set_value('STOP_WORD','through');"
"ctxsys.driimp.set_value('STOP_WORD','thus');"
"ctxsys.driimp.set_value('STOP_WORD','to');"
"ctxsys.driimp.set_value('STOP_WORD','too');"
"ctxsys.driimp.set_value('STOP_WORD','until');"
"ctxsys.driimp.set_value('STOP_WORD','ve');"
"ctxsys.driimp.set_value('STOP_WORD','very');"
"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','what');"
"ctxsys.driimp.set_value('STOP_WORD','when');"
"ctxsys.driimp.set_value('STOP_WORD','where');"
"ctxsys.driimp.set_value('STOP_WORD','whether');"
"ctxsys.driimp.set_value('STOP_WORD','which');"
"ctxsys.driimp.set_value('STOP_WORD','while');"
"ctxsys.driimp.set_value('STOP_WORD','who');"
"ctxsys.driimp.set_value('STOP_WORD','whose');"
"ctxsys.driimp.set_value('STOP_WORD','why');"
"ctxsys.driimp.set_value('STOP_WORD','will');"
"ctxsys.driimp.set_value('STOP_WORD','with');"
"ctxsys.driimp.set_value('STOP_WORD','would');"
"ctxsys.driimp.set_value('STOP_WORD','yet');"
"ctxsys.driimp.set_value('STOP_WORD','you');"
"ctxsys.driimp.set_value('STOP_WORD','your');"
"ctxsys.driimp.set_value('STOP_WORD','yours');"
""
"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:
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 LOG_MSG_OTS. Index creation will be skipped
Import terminated successfully with warnings.