[AccessD] Recreating an Oracle Environment - Learning Exercise based on a production instance as a model

Hi William:

It is all possible as I did exactly that a few years ago when I was testing
a client's application which used MS Access as the FE and Oracle as a BE
using ADO-OLE.

The beauty of ADO is that you can be connected to multiple data sources
simultaneously so you can even "pump/stream" data from one set of tables to
another across the network or web.

It is a fairly big subject so you would have to narrow down your questions.

Jim 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Benson, William
(GE Global Research, consultant)
Sent: Saturday, December 08, 2012 9:39 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] Recreating an Oracle Environment - Learning Exercise
based on a production instance as a model

Kind Experts, Gurus, and children of all ages,

I currently attach to oracle drivers to a GE database. I would like to know
if it is feasible to copy the GE database SCHEMA (note, no data) down to my
hard drive (replicating its structure, as it were) and then port this over
to my home machine so that, were I to have downloaded and installed a copy
of Oracle (presuming they have a free copy) I can continue my forays into
the world of interactive database programming via ADO. I have only SQL
Developer 3.something as a tool.

I am not interested (nor would it be ethical) to involve myself with the GE
data, but I doubt that the table structure under the given owner would be an
issue for that company.

Of course, the database itself has lots and lots of stuff that I never see,
not being an admin on the Oracle server. I log in as a user, and see
whatever is available in user_all_tab_cols or whatever, plus some views and
triggers and sequences and so forth. But basically, I already set up the
database with tables, PKs, FKs, triggers, sequences, and it works great for
uploading and downloading stuff from Excel - but I am trying to create an
offline environment I can continue to do all the same development and
testing - form a local machine perspective only.

I am sure you all know what I am getting at even if I am not expressing
myself well. Please give me some pointers, thanks a ton.


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com