Re: How to refresh

What are "all the problems with triggers and constraints"? If you're talking about unique/primary/foreign keys, disable constraints and those pesky things that protect the integrity of your data will no longer be in your way. Of course, you will not know whether your data is inconsistent or not, but what we don't know doesn't hurt us. Isn't that an old platitude? If you want to move some data from one database to another, it helps if you have some mechanisms to help, like "DATE_CREATED" and "USER_CREATED" columns in each of your database tables. What you're really talking about is called "snapshot based replication". You will, however, need some programming to load the data back into the base tables. Let me recommend excellent works of Randall Schwartz, Tom Christiansen, Larry Wall,Sriram Srinivasan, Damian Conway, Tim Bunce and Aligator Descartes. They have written books that can show The Only Right Way (TM) of programming.

On 12/16/2003 09:54:48 AM, "Smith, Ron L." wrote:
> I need to do a refresh of a test database using production data. We use
> import for this. In the past we have always dropped the schemas (4 or
> 5), recreated the schemas, and then did a full import with ignore=n.
> This time the user does not want to lose any of the new functions and
> procedures that are in test, but not in prod. Instead, they would like
> to just refresh the table data. Last time we tried this we had all
> kinds of trouble with functions, triggers, constraints, etc... and ended
> up doing a full import.
>
> Is there a tried and true way to just refresh the table data without
> losing anything else and without having all the problems with triggers
> and constraints?
>
> Thanks!
> Ron
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Smith, Ron L.
> INET: rlsmith_at_kmg.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

Mladen Gogala
Oracle DBA

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).