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!

EXP-00091 & IMP-00017 : Exporting & Importing questionable statistics &

927253May 7 2012 — edited May 7 2012

I am getting following error when i'm doing the export

about to export BA360EVAN's tables via Conventional Path ...
. . exporting table REG_ASSOCIATION 203 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table REG_CLUSTER_LOCK 1 rows exported
EXP-00091: Exporting questionable statistics.
EXP-00091: Exporting questionable statistics.
. . exporting table REG_COMMENT 181 rows exported
EXP-00091: Exporting questionable statistics.

After finish the export i have done the import & below error comes Plz i want to know the exactly scenario. I want complete answer

IMP-00017: following statement failed with ORACLE error 942:
"CREATE TRIGGER "BA411EVAN".HYBRID_ROLE_TRIGGER"
" BEFORE INSERT"
" ON HYBRID_ROLE"
" REFERENCING NEW AS NEW"
" FOR EACH ROW"
" BEGIN"
" SELECT HYBRID_ROLE_SEQUENCE.nextval INTO :NEW.UM_ID FRO"
"M dual;"
" END;"
IMP-00003: ORACLE error 942 encountered
ORA-00942: table or view does not exist
IMP-00017: following statement failed with ORACLE error 942:
"CREATE TRIGGER "BA411EVAN".HYBRID_USER_ROLE_TRIGGER"
" BEFORE INSERT"
" ON HYBRID_USER_ROLE"
" REFERENCING NEW AS NEW"
" FOR EACH ROW"
" BEGIN"
" SELECT HYBRID_USER_ROLE_SEQUENCE.nextval INTO :NEW.UM_I"
"D FROM dual;"
" END;"

Import error is impotant