Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
datadeploy with oracle synonyms
avdhut
I am trying use datadeploy to load the contents in Oracle database. I have two schemas in the database.
First schema has got all the objects and is a owner schema. Synonyms are created in the second schema.
Our application is supposed to use the second schema and work only with the synonyms.
Unfortunately teamsite checks for the existence of objects in the user_tables table. Since we need to use the synonym, the deployment fails. (Second schema does not have the resource privilege)
Is there any way
to disable this feature. (by default oracle will resolve the query to use synonym)
enable use of synonyms so that datadeploy will understand the synonym and use it instead of table.
Please let me know how can I resolve this problem.
Find more posts tagged with
Comments
There are no comments yet