Re: Refreshing data in a TEST instance.

From: Fender <nospam.efender_at_ix.netcom.com>
Date: 2000/07/12
Message-ID: <8kij01$icq$1@slb6.atl.mindspring.net>#1/1

I typically perform these basic steps:
On LIVE side:
exp system/manager full=y file=exp.dmp consistent=y direct=y One TEST side:
Disable all triggers
Truncate all tables
Drop all sequences
imp system/manager file=exp.dmp fromuser=live touser=test ignore=y buffer=100000

Unfortunately, I'm having problems with the sequences. Here's a UNIX shell script that will disable, truncate and drop, you should be able to adapt it for NT.

ORACLE_SID=test ; export ORACLE_SID
sqlplus test/manager << EOF
set pagesize 0
set feedback off
set heading off
spool disable_triggers.sql
select 'alter trigger '||trigger_name||' disable;' from user_triggers; spool off
spool truncate_tables.sql
select 'truncate table '||table_name||';' from user_tables; spool off
spool drop_sequences.sql
select 'drop sequence '||sequence_name||';' from user_sequences; spool off

@disable_triggers
@truncate_tables
@drop_sequences

exit
EOF "Nick" <NICKB_at_KUBOTA.CO.UK> wrote in message news:396c88a5.0_at_tahiti.alcom.co.uk...
> 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 Wed Jul 12 2000 - 00:00:00 CDT