Re: Select all tables from schema

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.