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

Benson, William (GE Global Research, consultant) Benson at ge.com
Sat Dec 8 11:38:35 CST 2012


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.




More information about the AccessD mailing list