Hi John
> 1. Is it possible to setup a database that is a subset of a production
> database for training purposes (Oracle 10.7 and Oracle 11i)?
> If so, how is this done?
If the schema is of any complexity this can be quite difficult. If you do it
manually you should prepare yourself for a trip through PL/SQL hell. Not
only do you have to get the data from every table required to support the
rows in the others - but you also have to sift out duplicates.
I've needed to do this a lot in the past and have not been terribly happy
with the tools on the market. So I wrote my own. The software is called
DataBee and it is available now. I haven't really started to promote it
yet - I'm waiting until the end of June when I'll have quit my day job.
There are two other software products that can also cut subsets (both are
more expensive and harder to use than DataBee IMHO)
DataManager from Quest http://www.quest.com
Checkmate from BitByBit http://www.bitbybit.com
DataBee can be found at http://databee.com/
Cheers
Dale Edgar
Net 2000 Ltd
[EMAIL PROTECTED]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Dale Edgar
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
