Re: move data from Production to test database everyday
From: Frank <fvanbortel_at_netscape.net>
Date: Wed, 05 Mar 2003 21:44:41 +0100
Message-ID: <3E6661B9.9080805_at_netscape.net>
Date: Wed, 05 Mar 2003 21:44:41 +0100
Message-ID: <3E6661B9.9080805_at_netscape.net>
oraclehyd wrote:
> Hi,
>
> How to move data from live production database which is huge in size
> (let us say 100GBs) to test database everyday. Export and import
> would be the worst tool. I guess it would be backup and recovery with
> Rman. But anyone can give out some steps or procedures to do it. I
> will appreciate all help.
How about transportable tablespaces? Uses imp and exp, too, but datafiles are physically copied off a running production site.
-- Regards, Frank van BortelReceived on Wed Mar 05 2003 - 21:44:41 CET