Re: Select all tables from schema

>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

Hi Mark,

On a related note I once did a data migration with a company in Melbourne, OZ using MS Access to migrate the data from an Oracle database to an AS400. We created select into's in MS Access from Oracle to AS 400 using ODBC and then we created views in Oracle that looked like the AS400 tables so the select into's were very simple. I was amazed by the performance when we ran it on quite large amounts of data. MS Access i supposed just acted like a pipe between the two systems.

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.