Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2007
    Posts
    5

    Unanswered: Export OK - Import errors

    hi all. !!
    I have a dmp without errors and I send it to other person and He have errors during the import proccess like missed packages
    can be the cause a different character set? or diferent version of export utility?

    This is my character set
    Export done in WE8ISO8859P1 character set and AL16UTF16 NCHAR character set

    and this is the character set of the other db.
    Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set.

    can this be the problem??

    Thanks...

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    And database versions, along with used export and import versions were ...?

  3. #3
    Join Date
    Dec 2007
    Posts
    5
    sorry,
    my db is Oracle 9.2.0.7.0
    and the other is Oracle 9.2.0.1.0

  4. #4
    Join Date
    Dec 2007
    Posts
    253
    Any chance you could post the errors too (might be relevant)

  5. #5
    Join Date
    Mar 2007
    Posts
    623
    along with used export and import versions
    Let me suppose, those versions are the same as the database versions.
    Then, in general, you cannot import dmp file created with HIGHER version of EXP than the IMP version (it may work sometimes, but I would not depend on this).
    Not sure about importing with higher version of IMP than the DB version, but I would not try it.
    I would rather export with lower version of EXP (in your case 9.2.0.1. at least).

  6. #6
    Join Date
    Dec 2007
    Posts
    5
    I suppose the same...
    i export with a less version of export or import with higer version.

    -Error(24,44): PLS-00201: identifier 'SUBSTRING' must be declared (en ap_rev_w_arbol_dependencias)

    -Error(78,84): PL/SQL: ORA-00904: "DATEDIFF": invalid identifier (en ap_rev_w_cant_obj_detalle)

    -Error(356,7): PLS-00201: identifier 'EXEC_SQL' must be declared (en AP_REV_W_COMPARACION)

    -Error(1211,27): PL/SQL: ORA-00904: "UCASE": invalid identifier (en ap_rev_w_cons_lista_ed)

    SUBSTRING,DATEDIFF,EXEC_SQL and UCASE are functions of a schema included in the export.

Posting Permissions

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