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!

ODI creating synonym with same name as view in same schema

RG 007Nov 3 2012 — edited Nov 6 2012

Hi Gurus,

I am trying to load data from Oracle to Oracle(same database) , I have only two schema
1. Source schema 2. wrk_n_Target . this 2nd schema also working as work schema for source.
work Schema and Target are same .

I have chosen LKM: Oracle to Oracle DB Link, on target IKM: Oracle incremental update, CKM is Oracle .

When I run interface it creates view on Work Schema(when working work schema for source), then it tries to create synonym with same name on the same schema(working on work schema for target) schema.
So, I am getting error: object with same name already exist.

I think, if there is a way to avoid creating of synonym, since

Please advice.

I will really appreciate any input on this.

Thanks

Edited by: rohtashgoyal on Nov 3, 2012 8:14 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 4 2012

Added on Nov 3 2012

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

7 comments

1,031 views