Home » RDBMS Server » Server Utilities » shadow copy (Oracle 10g)
shadow copy [message #317980] Mon, 05 May 2008 03:41 Go to next message
gangulyz
Messages: 6
Registered: April 2008
Junior Member
Hi ,

Need urgent help.
I have to create a process such that data from PROD environment is copied continuously to another schema , kind of shadow copy. the frequency of copying should be configurable for each table.


I have created separate jobs for each table (around 47) with the frequency of copying stored in a table SHADOW_COPY_FREQUENCY.I have created the jobs through DBMS_SCHEDULER calling a generic procedure .

We have to take care of the updates and deletes in the base tables.

Is there a way to achieve this?

Thanks in advance.

Regards
Som

[Updated on: Mon, 05 May 2008 03:44]

Report message to a moderator

Re: shadow copy [message #317991 is a reply to message #317980] Mon, 05 May 2008 04:21 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you consider use of materialized views and their refreshing capabilities?

Report message to a moderator

Re: shadow copy [message #318170 is a reply to message #317991] Tue, 06 May 2008 00:27 Go to previous message
gangulyz
Messages: 6
Registered: April 2008
Junior Member
Thanks a lot for the suggestion , M views really helped .

Regards
Som

Report message to a moderator

Previous Topic: import Problem
Next Topic: ora8i with form 60 on win xp professional
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Apr 09 00:01:19 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.