Re: Database instance copying

"Grant Fitzgerald" <gfitzger_at_hotmail.com> wrote in message news:cdf183bb.0106061227.34e6e3fc_at_posting.google.com...
> 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).
>

I'd have thought that ruled out exp/imp.

My best guess would be that you should look into one of

1. Replication.
2. Standby databases. You could swap between two databases on a regular period.

--

Niall Litchfield
Oracle DBA
Audit Commission UK