 Tool for ER-Like Diagram [message #604723] |
Fri, 03 January 2014 07:58  |
 |
suddhasatwa_oracle
Messages: 24
Registered: January 2014
|
Junior Member |
|
|
Hello All,
I have two schemas A and B. Both are on same database running on Oracle 11.2.0.1. I have 3 tables in A from where I am loading data into B into one table. To do so I am using a simple SQL Query. After providing all the grants and after creating the required synonyms, I am able to run the query and it is inserting the correct records into the target table in B.
Now, I would like to generate a diagram of this operation. I am in serious need of a easy to use tool which can be used to create a diagram showing this data flow with details like which columns are getting selected from A to B by my SQL Query.
Kindly advice if there are any such tools available.
For any queries, kindly reply.
Best Regards,
Suddhasatwa
[Updated on: Fri, 03 January 2014 07:59] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
