Re: join view with/without archiving on?

From: Jeff Hunter <jeffh_at_btitelecom.net>
Date: Mon, 20 Sep 1999 19:07:14 -0400
Message-ID: <37e6be5a@defiant.btitelecom.net>

Sure, no problem.

Archivelog mode only affects operations that hit the redo logs in any particular instance. For example, if you changed data in your view via an update query, the changes would be archived on A, but not on B.

chrisoc_at_ans.net wrote in message <7s5oet$nqe$1_at_nnrp1.deja.com>...
>
>
>In Oracle 8 and after,
>on Solaris (in case it matters) can a view be created joining Table_A
>from instance_A
>and Table_B from instance_B when A is running in archivelog
>mode and B is not?
>
>Chris O'Connor
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Sep 20 1999 - 18:07:14 CDT