Re: Copy data from live database to test database

Hi,

This may not be the most eligent method but, I create a script that:

1. drops the test instance (and files)
2. rebuilds the instance (and tablespaces)
3. imports the most current export of the live.

If the database is large, this might take a while but if it's not so big, this and option.

Dave S.

>>We have wo databases, one for LIVE transactions and the other for
>>testing/training, hence called TEST.
>>
>>I would like produce a script for updating the TEST database with all the
>>transactions currently in the LIVE database.

<<<< SNIP>>>>

>Thanks
>
>Umesh Jagannatha
>umesh_at_esystem.com
>
Received on Sat May 30 1998 - 00:00:00 CDT