Re: How to duplicate an opened database every night ?

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Wed, 5 Dec 2001 14:17:06 GMT
Message-ID: <3C0E2C62.C6A7350@peasland.com>

> I would like to duplicate or replicate an opened database every night.
> My database size is around 45 GO. I could not make an exp/imp because
> of its size. As the database is opened 24H/24, how can I replicate it
> ?
>
> Oracle version is 8.0.5.2.1
> system is HP-UX 11.0

If you upgrade to Oracle 8i, then you can use Transportable Tablespaces to accomplish your needs. It's quick and easy and free. So this solution all depends on your ability to upgrade your database to Oracle 8i.

HTH,
Brian Received on Wed Dec 05 2001 - 08:17:06 CST