Matthias Hoys wrote:
> "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
According to tahiti.oracle.com you are correct. But I haven't seen or
worked with 8i in many years so I'll trust the docs.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Mar 14 2006 - 10:33:13 CST
