Oracle8i schema diagram for system tables?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle8i schema diagram for system tables?

  1. #1
    Join Date
    Apr 2003
    Posts
    3

    Question Oracle8i schema diagram for system tables?

    Does anyone know if there is an electronic version of the Oracle8i schema diagram for the system tables/views? I would like to be able to reference a schema diagram while building queries against v$ views. I realize I could simply do a describe against the objects, but I was hoping for something a little easier to use, like a schema diagram (with short descriptions of columns). Any help would be appreciated.

    Thanks,
    Michael O.

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,967
    I have a poster of the Oracle data dictionary that has most of the Oracle sys tables/views columns and datatype. I also use dba_studio to look at sys procedure, and packages that I want to use. I can look at the procedure or package header and read the notes on how to use objects. You can also look at the dict table to get an idea of what tables/views are out there and what they are used for.

  3. #3
    Join Date
    Apr 2003
    Posts
    3
    That poster you refer too is what I had in mind - hoping to find an electronic version (with similar info). ...Appreciate your help.

    Thanks :-)
    Michael O.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width