[AccessD] OT: Extract Oracle Schema Information

You could try one of these UML modeling tools to reverse engineer 
Oracle, Does SQL and Access as well
They both have 30 day trials and are reasonably priced under $500. I 
have used EA only for looks at large Access databases to workout ER diagrams
Enterprise Architect
http://www.sparxsystems.com.au/ea_faq.htm
or
Case Studio 2
http://www.casestudio.com/enu/

chizotz at mchsi.com wrote:

>I know this is pretty far afield, but I could sure use some help. Pointers to 
>help would be great, no need for a big off-topic discussion here. Private 
>emails also would be very welcome, either to chizotz at mchsi.com or 
>rrallen at tribmail.com.
>
>I have a huge (ca. 400 table, 250 view) Oracle database with no schema 
>information available. Is there a utility somewhere that can pull out the 
>table names, datatypes, and relationships quickly for me? I've tried reverse 
>engineering it with Visio 2003, which is great except that it is so huge that 
>Visio just creates a very messy and densly packed mess that will still take me 
>days or even weeks to sort out. I do _not_ have access to any Oracle tools and 
>can not use SQL*Plus or anything like that. I can connect to this database via 
>ODBC only.
>
>Thanks for any suggestions,
>
>Ron Allen
>Circulation Systems Administrator
>Columbia Daily Tribune
>573-815-1604
>rrallen at tribmail.com
>  
>

-- 
Marty Connelly
Victoria, B.C.
Canada