Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

IMP-00017: failed with ORACLE error 942 (SYS.DBMS_REPUTIL.SYNC_UP_REP)

user2226836Aug 25 2010 — edited Aug 25 2010
Hi,

I am trying to exp a table from an oracle 9i db to an oracle 11g db.
exp USERID=user1/pass1@db9i TABLES=test FILE=test.dmp ROWS="y" statistics="none" GRANTS="n" INDEXES="n" TRIGGERS="n" CONSTRAINTS="n"

While trying to import i get an error
*"IMP-00017: following statement failed with ORACLE error 942:*
*"BEGIN SYS.DBMS_REPUTIL.SYNC_UP_REP('CYGENT_ADMIN','AGENT_ROOT_MAP'); END;"*

_when i do_
imp USERID=user2/pass2@db11g TABLES=test FILE=test.dmp FROMUSER=user1 TOUSER=user2 SHOW=Y
the last line i see is
*"BEGIN SYS.DBMS_REPUTIL.SYNC_UP_REP('CYGENT_ADMIN','AGENT_ROOT_MAP'); END;"*

_Question_
What do i need to do so that the last line (SYNC_UP_REP) is not included in the export dump.
Have tried searching for this but without much luck.

Appreciate the help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 22 2010
Added on Aug 25 2010
1 comment
1,317 views