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 -> Consolidating snapshots into one

Consolidating snapshots into one

From: <anguyen644_at_my-dejanews.com>
Date: Thu, 15 Oct 1998 22:10:26 GMT
Message-ID: <705rsi$2ls$1@nnrp1.dejanews.com>


Hello,

Has anyone out there been successful in implementing a consolidated snapshot? That is, let's say you have TableA on each database (DB1, DB2, and DB3). You would like to consolidate all three TableA's into one "master" TableA stored on DBMaster. Is there a way that you can do this via snapshots? I know we get around via triggers but that's too much when you're talking about 100+ tables per db. Please send reply to alex.nguyen_at_attws.com.

Thanks,
-Alex

-----== Posted via Deja News, The Leader in Internet Discussion ==-----
http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Oct 15 1998 - 17:10:26 CDT

Original text of this message

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