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

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?

Try running @$oracle_home/rdbms/admin/utlrp.sql in target DB and try import again

Any version differance in imp/exp..?

Quote:

---

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.

You might be getting hit by BUG#3011680