Database instance copying

From: Grant Fitzgerald <gfitzger_at_hotmail.com>
Date: 1 Jun 2001 05:38:10 -0700
Message-ID: <cdf183bb.0106010438.7ff3c875@posting.google.com>

Hi,

I currently have a system which has two C-ISAM databases - one which is updateable by users and one (the live DB) which is read-only. The system's application programs only access the read-only DB so that the users can't interfere with the live DB. The users make changes to the updateable one and, when changes are complete, a new read-only database is created by copying the new data into it (overwriting what was previously there).

I am currently in the process of investigating how the ISAM database can be replaced by Oracle and would really appreciate some advice about the best way to copy data between two DB instances. The options I have thought about so far are:

full export/import (performance issues?)
8i's transportable tablespaces
Snapshot replication

What are the pros/cons of each of these? Is there another option I should be looking at? If anyone has any advice I'd be glad to hear it.

Thanks in advance,
Grant Received on Fri Jun 01 2001 - 07:38:10 CDT