Members Members   Search Search   Help Help   Register Register   Login Login   Home Home
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: 4
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: 5640
Registered: June 2005
Location: Croatia, Europe
Senior Member
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: 4
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) ] [ ]

Current Time: Sat May 17 00:22:50 CDT 2008

Total time taken to generate the page: 0.21410 seconds
.:: Forum Home :: Site Home :: Wiki Home :: Contact :: Privacy ::.