Re: Copy data from live database to test database
From: Dave S <DS_at_nospam.com>
Date: 1998/05/30
Message-ID: <6kq5ng$88q$1_at_tor-nn1.netcom.ca>#1/1
Date: 1998/05/30
Message-ID: <6kq5ng$88q$1_at_tor-nn1.netcom.ca>#1/1
Hi,
This may not be the most eligent method but, I create a script that:
- drops the test instance (and files)
- rebuilds the instance (and tablespaces)
- 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 CEST