-
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?
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'
-
Try running @$oracle_home/rdbms/admin/utlrp.sql in target DB and try import again
-
Any version differance in imp/exp..?
-
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
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|