• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 276
  • Last Modified:

export Oracle diagram from Oracle DB including VIEWS

Dear Experts,

 How do I export Oracle DataBase diagram inclluding VIEWS also, to any tool like Visio or something else more friendly to make a revers engineering for Database diagram

Thanks
0
Jamil Muammar
Asked:
Jamil Muammar
1 Solution
 
slightwv (䄆 Netminder) Commented:
I'm not aware of a good way to 'export' the database design where you can plug it into a tool.

Visio has a reverse engineering piece built into it.  You point it to the database and it grabs everything for you.

Might I also suggest Oracle's SQL Data Modeler.  It also reverse engineers your schema for you:
http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html
0
 
Jamil MuammarAuthor Commented:
Hello slightwv,

 I checked this tool, unfortunately it dosn't give the relations between the View.

In other words, I need to get schema for each View from which tables / View it;s built

Thanks
0
 
Jamil MuammarAuthor Commented:
I need a tool to draw schema for Views dependency including multiple Databases
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
slightwv (䄆 Netminder) Commented:
>>I need to get schema for each View from which tables / View it;s built

I've never seen a tool that will decompose a view into the base tables and diagram it for you.
1
 
slightwv (䄆 Netminder) Commented:
I added the Databases and Enterprise Software Topic Areas to see if it will pull in some additional Experts.
0
 
PortletPaulCommented:
I have not seen reverse engineered diagramming of views either but my exposure to such tools is limited i guess.

Does "Erwin" do it perhaps?

Also in recent versions of Visio I think the db reverse engineering has bèen removed. i may be wrong so may nèed to check.
0
 
Bill PrewCommented:
I'm pretty sure TOAD for Oracle can generate ER diagrams from the database schema, not sure if it will handle views as you desire.  Unfortunately I don't have it installed currently so can't quickly check.

https://www.quest.com/products/toad-for-oracle/

Also, I think Oracle SQL Developer has the ability to diagram out the tables that make up a view, but I haven't used that tool a lot.

http://www.oracle.com/technetwork/issue-archive/2014/14-may/o34sqldev-2193423.html

A couple of other tools that you might want to look at, I have no experience, but the first one looks interesting and seems to have views as well as tables support.

http://www.sumsoftsolutions.com/erd4sqldev/

http://www.datanamic.com/dezign/erdiagramtool.html

~bp
3
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
Visio database reverse engineering is back! I don't know whether it will display view relationships in the way that you'd like, but if it doesn't, you have an opportunity -- the return of reverse engineering to Visio is in preview mode as of today, consequently, you will have an opportunity to provide feedback to the Visio development team.

Here's the announcement article.

Please note that the preview is currently restricted to Visio Pro for Office 365 and is not available for the desktop (msi installer) version of Visio Professional.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now