This content has been marked as final. Show 8 replies
Hmm, I'm surprised because I have definitely accessed functions, procedures, and packages via private synonyms with 10.2.0.4
Just curious, but did you also remember to assign proper grants to APPS on those objects from XXMY?
The first test I would do is to be sure that the function is runable from APPS via the synonym - so drop any public synonyms to the function to make sure that you are accessing it via the private one.
I have the same type of problem. Created a synonym in Schema2 for a procedure in Schema1, want to import this synonym proc but not visible in OWB while importing the transformation section; even i already selected the option of 'Use a synonym to look up objects'. I have already given full access on procedure to target schema. Currently using OWB11gR2.
You said in the previous message:
the most probably it is an OWB bug.
I think the only workaround is to create sepparate module for additional schemas in your target database -
location for this module will differ from target location only in Schema parameter
Can you elaborate in details?
I have a remote source DB in Oracle 7.3.4 and I need to connect to this source from OWB 11gR1. I use a bridge DB in Oracle 9.0.1 that have private synonyms created via DB link connecting to Oracle 7. I can import any tables/views form the bridge DB but cannot import the private synonyms.
I'm afraid you'll have to create dummy functions and procedures in the 9.0.1 Database invoking the real ones in the 7.3.4 DB through the DB-Link using normal PL/SQL. Then you should be able to import the dummy ones. If that doesn't work, you'll have to create the dummy ones in the target schema of OWB 11gR1.
I have a similar problem in OWB 11.2 pointing at an Oracle 9.2 database.
We're migrating our OWB 10.1 (Oracle 9.2) to OWB 11.2 on a 11.2 database, we're coming from windows and going to Sun Solaris.
Both databases can see each other, I've created a db-link in Oracle 11.2 pointing to Oracle 9.2 (I tried both with private and public DB-links).
I'ce created a sunonym in the 11.2 database point over the db-link to the table in the 9.2 database.
In SQL developer I can see the table, select, insert, update and delete.
When I'm in OWB and I try to import tables (synonyms checked) I do not see any of the synonyms created.
Am I still doing something wrong?
I can create another location in OWB 11.2 pointing to the 9.2 database but I'd like to avoid this setup.