[AccessD] OT: Extract Oracle Schema Information

Gustav Brock gustav at cactus.dk
Fri Apr 23 11:48:07 CDT 2004


Hi Ron

Have a look at:

  http://www.thekompany.com/products/dataarchitect/

  http://www.thekompany.com/products/dbradar/

and Dezign for databases:

  http://www.datanamic.com/

/gustav


> 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




More information about the AccessD mailing list