How to export relationships from exiting database [message #531312] |
Tue, 15 November 2011 03:19 |
|
mniedz
Messages: 2 Registered: November 2011
|
Junior Member |
|
|
Hello,
I'm a new one in here. I have started working with databases and my task is to recognise one old oracle db (8.1.7) and learn how it works.
I want to export relationships model from this db. How can I do it?
P.S Sorry for my terrible english...
|
|
|
Re: How to export relationships from exiting database [message #531313 is a reply to message #531312] |
Tue, 15 November 2011 03:45 |
|
Littlefoot
Messages: 21821 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
You'd need a tool that is capable of creating an ER-model. I know that Quest software's TOAD has it, and I'm pretty much sure that Oracle's SQL Developer knows how to do that. As SQL Developer is free (while TOAD is not), perhaps you'd rather check its capabilities first.
Or, use any other tool Google finds for you.
Basically, you might do that manually, but it would take a long time (depending on schema complexity and (non)existing relationships)).
[Updated on: Tue, 15 November 2011 03:45] Report message to a moderator
|
|
|
|
|