[AccessD] OT: Extract Oracle Schema Information

Create an Access Passthru query to use the native oracle syntax for
viewing Oracle database/table properties.

http://tahiti.oracle.com/pls/db92/db92.drilldown?book=a96525&remark=doci
ndex&expand_all=1 

will give you the 9i documentation search engine - watch wrapping

HTH
Patti

******************************************************************
*Patricia O'Connor
*Associate Computer Programmer Analyst
*OTDA - BDMA
*(W) mailto:Patricia.O'Connor at dfa.state.ny.us
*(w) mailto:aa1160 at dfa.state.ny.us
******************************************************************
 

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> chizotz at mchsi.com
> Sent: Friday, April 23, 2004 12:29 PM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] OT: Extract Oracle Schema Information
> 
> 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
> --
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>