Re: Database instance copying

Hi,

Thanks for your reply, but what I'm actually doing is rewriting the ISAM code with eqivalent Oracle code. I'm looking to replace the current (ISAM) DB copy functionality with it's Oracle equivalent and I'm unsure what the quickest way to do this is (I should have also mentioned that I can't do it during system downtime - we need 99.999% availablity).

Grant

Palmer <palmer_at_netdoor.com> wrote in message news:<3B17BBDB.3C44E08B_at_netdoor.com>...
> 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 Wed Jun 06 2001 - 15:27:38 CDT