Re: Copy cold backup to another DB

From: Matthias Hoys <anti_at_spam.com>
Date: Mon, 13 Mar 2006 23:02:07 +0100
Message-ID: <4415ebe1$0$29463$ba620e4c@news.skynet.be>

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1142267847.641705_at_yasure.drizzle.com...
> Carlos Antonio wrote:
>> Hello,
>>
>> I'm new in Oracle.
>>
>> I've got two DBs one in production and other which is a test db.
>> Everty night I make a cold backup of the production DB.
>>
>> Now, I want to copy these files to the TEST database.
>>
>> In plain english, how can this be done?
>>
>>
>> Thanks in advance,
>>
>>
>>
>> Carlos
>
> In plain English ... version numbers are important.
>
> Assuming 9i or above ... transportable tablespaces.
> You will find information and demos in Morgan's Library at
> www.psoug.org and following the DBA links at www.caleb.com.
>
> HTH
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)

Oracle 8i supports transportable tablespaces too, no ?

Matthias Received on Mon Mar 13 2006 - 16:02:07 CST