Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
System Management and Integration
This discussion is archived
on Dec 14, 2012 3:30 PM by 961221
reverse engineering tables of different schema/user in oracle
Dec 14, 2012 3:06 PM
Is it possible to reverse engineer tables of another user or schema in ODI if I have read permission on that schema?
for e.g. I created a data server connection to oracle db with username SE and I'm trying to reverse engineer tables of another user SW. SE has read permission on SW.
Is this possible?
Thank you for looking into this.
I have the same question
Show 0 Likes
This content has been marked as final.
Show 1 reply
Re: reverse engineering tables of different schema/user in oracle
Dec 14, 2012 3:30 PM
in response to
It is possible if both users are in the same db and the other schema needs to be selected in the physical schema under topology.