Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: error during import......

    hi,
    I imported my file.dmp

    imp system/manager@db fromuser=tom touser=tom file=C:\file.dmp log=C:\file.log

    AT TO BEGINNING I get this error:
    Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
    With the Partitioning option
    JServer Release 9.0.1.1.1 - Production

    Export file created by EXPORT:V08.01.07 via conventional path
    import done in WE8DEC character set and AL16UTF16 NCHAR character set
    import server uses WE8MSWIN1252 character set (possible charset conversion)
    export client uses WE8ISO8859P1 character set (possible charset conversion)
    export server uses UTF8 NCHAR character set (possible ncharset conversion)
    . importing TOM's objects into TOM
    IMP-00017: following statement failed with ORACLE error 6550:
    "BEGIN "
    "sys.dbms_logrep_imp.instantiate_schema(schema_nam e=>'TOM', export_db_name=>"
    "'CSNEW.US.ORACLE.COM', inst_scn=>'11632185');"
    "COMMIT; END;"
    IMP-00003: ORACLE error 6550 encountered
    ORA-06550: line 2, column 1:
    PLS-00201: identifier 'SYS.DBMS_LOGREP_IMP' must be declared
    ORA-06550: line 2, column 1:
    PL/SQL: Statement ignored
    . . importing table "AC" 0 rows imported
    . . importing table "ACBU" 0 rows imported
    . . importing table "ACTIVITYTYPE" 0 rows imported
    . . importing table "ACTIVITY_LOG" 0 rows imported
    . . importing table "ADVISORY" 0 rows imported
    . . importing table "AFM_ACTS" 96 rows

    but after every table is imported correctly.

    Why I get this error?
    This is an important error?
    How Can I resolve it?
    Problem with version?

    Thanks
    Raf

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    you exported using an 817 utility and then you import using a 9i utility.
    possible problems there.

    The normal rule is:
    1. When importing, export the data using the version you plan on importing into.

    example #1:
    I want my 9i schema in my 8i db.
    Export the 9i data using the 8i export utility and then import with 8i import utility.

    example #2:
    I want my 8i schema in my 9i db.
    Export 8i data with the 9i export utility and then import into the 9i db using the 9i import utility.
    - 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
  •