- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- data relationalship in Oracle
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2004 08:31 AM
тАО05-12-2004 08:31 AM
I need to build a diagram showing the relationalship of the data items in the database somewhat like what I have seen in MS Access. Is there a way I can pull this information out of the Oracle database? I am using 9i r2 currently.
Steve
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2004 04:38 PM
тАО05-12-2004 04:38 PM
Re: data relationalship in Oracle
do you have Oracle Enterprise Manager (OEM)? this should show u some data objects linkages, if that is what u require.
regards.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2004 04:44 PM
тАО05-12-2004 04:44 PM
Solution1. Administer the complete Oracle environment, including databases, iAS servers, applications, and services.
2. Diagnose, modify, and tune multiple databases.
3. Schedule tasks on multiple systems at varying time intervals.
4. Monitor database conditions throughout the network.
5. Administer multiple network nodes and services from many locations.
6. Share tasks with other administrators.
7. Group related services together to facilitate administration tasks.
8. Launch integrated Oracle and third-party tools.
sks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2004 08:05 PM
тАО05-12-2004 08:05 PM
Re: data relationalship in Oracle
A colleugue have done it with AMC designor by reverse ingeenering.
Cheers
Nicolas
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2004 10:48 PM
тАО05-12-2004 10:48 PM
Re: data relationalship in Oracle
A very handy tool is the DBVisualizer from Minq Software. Take a look at http://www.minq.se/products/dbvis. With this tool you can see the relations between tables.
Regards,
H├Г┬еk
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-12-2004 11:05 PM
тАО05-12-2004 11:05 PM
Re: data relationalship in Oracle
dba_tables
dba_constraints
:)
Seriously, can't you do it by linking the Oracle tables in MS Access ?
Regards,
Fred
"Reality is just a point of view." (P. K. D.)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-13-2004 07:42 AM
тАО05-13-2004 07:42 AM
Re: data relationalship in Oracle
You might try the 30 day trial version of designer from
http://otn.oracle.com/software/products/designer/index.html
It can be a bit of a pain to install, but it's relatively easy to use.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО05-14-2004 03:08 AM
тАО05-14-2004 03:08 AM
Re: data relationalship in Oracle
ER Studio from Emarcadero (http://www.embarcader.co.uk/)
Quite good reverse engineering program, that can come with the execellents DBArtisan and Rapid SQL.
Regards,
Fred
"Reality is just a point of view." (P. K. D.)