| Author |
Message |
GreyBeard
*nix forums Guru Wannabe
Joined: 10 Mar 2005
Posts: 182
|
 Posted: Mon Feb 28, 2005 5:56 pm Post subject:
Re: tool drawing ora9 database relation schema???
|
|
|
On Mon, 28 Feb 2005 19:40:34 +0100, Frank van Bortel wrote:
| Quote: | Makes one wonder why the Swiss army gets those knives...
"preseeeeent... knive!" <g
|
Like any tool, it's very useful in appropriate circumstances. If I had
to dig a trench and had my druthers, I'd take a back hoe.
Have to admit though, having something that small which does 57 different
jobs just by unfolding parts of it is kewl!
FGB |
|
| Back to top |
|
 |
Frank van Bortel
*nix forums Guru
Joined: 19 Apr 2005
Posts: 804
|
| Posted: Mon Feb 28, 2005 5:40 pm Post subject:
Re: tool drawing ora9 database relation schema???
|
|
|
GreyBeard wrote:
| Quote: | On Mon, 28 Feb 2005 16:11:07 +0100, Frank van Bortel wrote:
GreyBeard wrote:
[snip]
Also: UML diagrams can also be achieved in JDeveloper (which is also
part of the Developer Suite bundle)
Can JDeveloper reverse engineer, like Designer can?
Because that was the OP's request.
From the JDeveloper 10g (9.0.5.1) OBE entitled "Designing, Modeling and
Generating Database Tables":
---------------
Step 3 - Import Tables from a Database
Connection
Now that you have a blank database diagram, you can directly import tables
from the database connection by dragging them onto the diagram. Importing
the tables creates the offline table definitions which you will work with
before creating the DDL to create new tables in a database.
1. To import tables from the connection you have to the database, click the
Connections tab so that the Connections Navigator is visible, or choose
View | Connection Navigator. Expand the Database, and HR nodes to see all
the database elements available through this connection.
---------------
I acknowledge the above technique may not fit within the requirements or
definition of 'Reverse Engineering'.
FWIW: I believe Designer is the better tool for this. IMO, JDeveloper is
trying to become a JOAT tool, which has it's uses. (But for close combat
a Bayonet may be better than a Swiss Army knife.)
/FGB
|
OK - kewl  did not know that will have to update, then.
Makes one wonder why the Swiss army gets those knives...
"preseeeeent... knive!" <g>
--
Regards,
Frank van Bortel |
|
| Back to top |
|
|
GreyBeard
*nix forums Guru Wannabe
Joined: 10 Mar 2005
Posts: 182
|
| Posted: Mon Feb 28, 2005 2:24 pm Post subject:
Re: tool drawing ora9 database relation schema???
|
|
|
On Mon, 28 Feb 2005 16:11:07 +0100, Frank van Bortel wrote:
| Quote: | GreyBeard wrote:
[snip]
Also: UML diagrams can also be achieved in JDeveloper (which is also
part of the Developer Suite bundle)
Can JDeveloper reverse engineer, like Designer can?
Because that was the OP's request.
|
From the JDeveloper 10g (9.0.5.1) OBE entitled "Designing, Modeling and
Generating Database Tables":
---------------
Step 3 - Import Tables from a Database
Connection
Now that you have a blank database diagram, you can directly import tables
from the database connection by dragging them onto the diagram. Importing
the tables creates the offline table definitions which you will work with
before creating the DDL to create new tables in a database.
1. To import tables from the connection you have to the database, click the
Connections tab so that the Connections Navigator is visible, or choose
View | Connection Navigator. Expand the Database, and HR nodes to see all
the database elements available through this connection.
---------------
I acknowledge the above technique may not fit within the requirements or
definition of 'Reverse Engineering'.
FWIW: I believe Designer is the better tool for this. IMO, JDeveloper is
trying to become a JOAT tool, which has it's uses. (But for close combat
a Bayonet may be better than a Swiss Army knife.)
/FGB |
|
| Back to top |
|
|
Frank van Bortel
*nix forums Guru
Joined: 19 Apr 2005
Posts: 804
|
| Posted: Mon Feb 28, 2005 2:11 pm Post subject:
Re: tool drawing ora9 database relation schema???
|
|
|
GreyBeard wrote:
[snip]
| Quote: |
Also: UML diagrams can also be achieved in JDeveloper (which is also
part of the Developer Suite bundle)
|
Can JDeveloper reverse engineer, like Designer can?
Because that was the OP's request.
--
Regards,
Frank van Bortel |
|
| Back to top |
|
|
GreyBeard
*nix forums Guru Wannabe
Joined: 10 Mar 2005
Posts: 182
|
| Posted: Mon Feb 28, 2005 1:11 pm Post subject:
Re: tool drawing ora9 database relation schema???
|
|
|
On Mon, 28 Feb 2005 14:21:41 +0100, Frank van Bortel wrote:
| Quote: | Yes - the Oracle tool is called Designer
|
Slight expansion: Designer is part of the Oracle Developer Suite bundle.
You normally go to the Developer Suite section of OTN to look for docco,
downloads, etc.
Also: UML diagrams can also be achieved in JDeveloper (which is also
part of the Developer Suite bundle)
FGB |
|
| Back to top |
|
|
Frank van Bortel
*nix forums Guru
Joined: 19 Apr 2005
Posts: 804
|
| Posted: Mon Feb 28, 2005 12:21 pm Post subject:
Re: tool drawing ora9 database relation schema???
|
|
|
Lore Leuneog wrote:
| Quote: | Hello.
Does there exist a tool that extracts table relations from a oracle 9
database and displays them as a table-relations graphic - similar as in
Access?
Thank you
Sincerely
Lore
Yes - the Oracle tool is called Designer |
--
Regards,
Frank van Bortel |
|
| Back to top |
|
|
Lore Leuneog
*nix forums beginner
Joined: 27 Feb 2005
Posts: 2
|
| Posted: Sun Feb 27, 2005 8:18 pm Post subject:
tool drawing ora9 database relation schema???
|
|
|
Hello.
Does there exist a tool that extracts table relations from a oracle 9
database and displays them as a table-relations graphic - similar as in
Access?
Thank you
Sincerely
Lore |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
Oracle
»
Tools
