Re: Database instance copying

Grant, Oracle's Import and Export utility use a proprietary format. I'd be surprised if you can create a file in the appropriate format using C-ISAM. Transportable Tablespaces are a physical storage option for designing Oracle databases, not a method for loading data. Snapshot replication is a technique for exchanging updates to data between existing oracle databases. I don't think any of these options will help you. You should look into Oracle's SQL*Loader utility described in the Utilities manual. I have used it numerous times to load data into an Oracle database successfully.
HTH
Cliff

Grant Fitzgerald wrote:

> 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 - 09:55:03 CDT