Home » Developer & Programmer » Designer » How to export relationships from exiting database
How to export relationships from exiting database [message #531312] Tue, 15 November 2011 03:19 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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

Re: How to export relationships from exiting database [message #531326 is a reply to message #531313] Tue, 15 November 2011 05:17 Go to previous messageGo to next message
mniedz
Messages: 2
Registered: November 2011
Junior Member
OK, but SQL Developer Data Modeler doesn't support Oracle 8... Is there any other free sortware that I can do this task?
Re: How to export relationships from exiting database [message #531341 is a reply to message #531313] Tue, 15 November 2011 07:01 Go to previous message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Littlefoot
use any other tool Google finds for you

Previous Topic: Converting to Column Oriented Architecture
Next Topic: Random form freeze
Goto Forum:
  


Current Time: Thu Mar 28 13:15:48 CDT 2024