error during import......
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: error during import......

  1. #1
    Join Date
    Jul 2002
    Posts
    228

    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 AFM's objects into AFM
    IMP-00017: following statement failed with ORACLE error 6550:
    "BEGIN "
    "sys.dbms_logrep_imp.instantiate_schema(schema_name=>'AFM', 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?

    Thanks
    Raf

  2. #2
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    Assuming you said ignore=y (which you probably did to get the other tables imported) it looks like your problem is a specific stored procedure that is not present on the target database. I am not familiar witht he specific package, but it looks like a log miner/rman procedure owned by sys. Maybe that isn't installed on your target db?
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  3. #3
    Join Date
    May 2003
    Posts
    46
    Try running @$oracle_home/rdbms/admin/utlrp.sql in target DB and try import again

  4. #4
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Any version differance in imp/exp..?
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    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
    I think the problem is due to this.
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  6. #6
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    You might be getting hit by BUG#3011680
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

Posting Permissions

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


Click Here to Expand Forum to Full Width