Database synchronization?

From: Kevin Cheung <kcheung_at_poboxes.com>
Date: Fri, 02 Jul 1999 22:59:48 +0800
Message-ID: <377CD3E4.C0434994@poboxes.com>

Our shop is running Oracle Applications 10.7 against Enterprise Server 7.3.3. The installation contains some shared product installation, i.e Oracle Purchase and some full installation, like Order Entry and Inventory.

There are 3 different enviroments for production, training and development. I was asked to synchronize data from production to other 2 environments. Is there any good way of doing this?

Approaches I think of:

Copy data files and then rename control file (Too clumsy since datafiles are really big)
Export the schemas for each installed product and then import into another environment (Need to truncate all the affected tables beforehand to avoid duplicated rows)

Any commetns? Received on Fri Jul 02 1999 - 09:59:48 CDT