| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Training Database
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
DataBee_at_DataBee.com
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dale Edgar INET: dale_edgar_at_yahoo.co.uk 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: ListGuru_at_fatcity.com (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).Received on Mon Jun 04 2001 - 15:52:03 CDT
 |
 |