Re: Copy cold backup to another DB

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)