Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: local copy of remote database -- how to solve this case?

Re: local copy of remote database -- how to solve this case?

From: Thomas Kellerer <JUAXQOSZFGQQ_at_spammotel.com>
Date: Thu, 31 May 2007 08:48:31 +0200
Message-ID: <5c79dvF2vbl0rU1@mid.individual.net> 






On 30.05.2007 23:52 T-BAG wrote:


> hello!

> 

> is it possible to create "simplified" local copy of the remote database 

> in an automatic/semi-automatic way? I don't need triggers, user roles 

> etc., just tables and indexes placed at two local tablespaces.




Why not use materialized views (using a DBlink as someone else has 
suggested) that way you can automate the process of synchronizing the 
local copy.



Thomas
Received on Thu May 31 2007 - 01:48:31 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US