Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2009
    Location
    Serbia
    Posts
    17

    Unanswered: Export/Import issue

    Hi guys!
    I have problem with importing schema from 9.2.0.4 db to 11.1.0.6 version.
    Both db are using Linux OS. I have done export of schema from 9i with no problem using EXP, but when i tried to do import to 11g with batch job that do this work it has stuck. I have then change system variables to use 10.2 version of EXP tool and i have done import of tables and indexes of source schema with no problem, but i had problem with triggers:

    IMP-00017: following statement failed with ORACLE error 942:
    "CREATE TRIGGER "HR".TRG_DINAMIKA_BI"
    "BEFORE INSERT ON USER_OBUKA.DINAMIKA FOR EACH ROW"
    "DECLARE"
    " OK BOOLEAN;"
    "BEGIN"
    " :NEW.STID := 0;"
    " :NEW.STID := PCK_Kljuc.SET_STID (:NEW.VDID, :NEW.DokID);"
    " IF :NEW.StID = 0 THEN"
    " NULL;"
    " END IF;"
    "END;"
    IMP-00003: ORACLE error 942 encountered
    ORA-00942: table or view does not exist
    IMP-00017: following statement failed with ORACLE error 942:

    any advice?

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Basically, export should be done with lower database version's EXP utility (9i in your case), while import should be done with target database version's IMP utility (11g in your case).

    As of ORA-00942 error, it appears that the table doesn't exist. Once the import is done, you might try to recompile all invalid objects (triggers, procedures, packages, ...) and see what happens. If there's still the same problem, check import's log file to see why this particular table was not imported.

  3. #3
    Join Date
    Sep 2009
    Location
    Serbia
    Posts
    17
    I have check all that, you already have mine log error in post...

  4. #4
    Join Date
    Jul 2003
    Posts
    2,296
    does USER_OBUKA.DINAMIKA exist in the new db?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Quote Originally Posted by prepek2000
    I have check all that, you already have mine log error in post...
    This error tells that trigger couldn't be created because table doesn't exist. Now check log file again and search for the "dinamika" table which was supposed to be imported into the "user_obuka's" schema. It appears that it was not imported.

  6. #6
    Join Date
    Jul 2003
    Posts
    2,296
    maybe it was hardcoded table name in lower case or something screwey like that.

    select owner, table_name from dba_tables
    where upper(table_name) = 'DINAMIKA';
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •