Analytics 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!

Error While Reverse Engineering a synonym

Sree1979-OracleFeb 7 2012 — edited Mar 5 2012

Hi All

I am trying to Reverse engineer a synonym in apps PAY_ALL_PAYROLLS_F i am getting an error like

com.sunopsis.dwg.SQLWorkReposException: ORA-00001: unique constraint (VTBW.PK_REV_COL) violated.i have check the Work Repository table SNP_REV_COL on which the constraint .PK_REV_COL has been defined.and this shows no records.I have imported So many synonyms with out any error.only for this particular synonym i am getting the error.i have created a view for the same table ,that i tried to reverse enginner that is working.any body suggest why the synonym import fails

Regards
Sree

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2012

Added on Feb 7 2012

#business-intelligence-applications, #data-integrator, #system-management-and-integration

3 comments

486 views