Re: Refreshing data in a TEST instance.

One way is to -
create a database link from TEST to LIVE in TEST truncate tableA
Rebuild tableA - insert into tableA select * from live.tableA.

If there is lots of tables you can write a script to do each one in turn or use export & import.

I have never tried export/import on NT but I'm sure the Oracle web site will have details.

Steve

Nick wrote:

> Hello all.
>
> Currently we have two instances - LIVE and TEST (Oracle 7.3.4 / NT 4.0).
>
> Could anyone tell me how to refresh the data in the TEST environment (which
> is 3 months old) with the LIVE data?
>
> We back up to tapes and .dmp file every night.
>
> Many thanks and regards to anyone who can help,
>
> Nick.
>
> -----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
> http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
> -----== Over 80,000 Newsgroups - 16 Different Servers! =-----
Received on Thu Jul 13 2000 - 00:00:00 CEST