8 Replies Latest reply on May 7, 2012 7:44 AM by CloudDB

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

    927253
      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