Re: Select all tables from schema

"Pete Finnigan" <plsql_at_petefinnigan.com> wrote in message news:TWPU9LB1gYUARxwH_at_peterfinnigan.demon.co.uk...
| hi,
|
| OK, i have done something similar in the past. I just created views in
| MS Access that just selected the data from Oracle. This was OK as there
| it was always possible to do an ODBC connection from access to Oracle.
| If you are off line with access then you could do select into in Access
| from Oracle and the data would then be available off line. From the
| simple tests we did at the time though the performance was better when
| selecting data live from Oracle rather than locally. Access didn't scale
| well when reasonable amounts of data were held in it.
|
| hth
|
| Kind regards
|
| Pete
| --
| Pete Finnigan
| email:pete_at_petefinnigan.com
| Web site: http://www.petefinnigan.com - Oracle security audit specialists
| Book:Oracle security step-by-step Guide - see http://store.sans.org for
details.

ditto on the ODBC -- I was actually surprised that it often acted rather intelligently by handing off joins on the attached tables and access queries (views) to the source database

with a live connection though, make sure you ODBC to an oracle account that only has select prigs on the required tables/views

on the MS-access side -- it's not too difficult to generate the attached table links by selecting from oracle's ALL_TABLES, ALL_VIEWS, or ALL_OBJECTS data dictionary views

;-{ mcs Received on Fri Mar 12 2004 - 05:52:09 CST