Re: join view with/without archiving on?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Mon, 20 Sep 1999 13:24:34 -0400
Message-ID: <rm3mNz38=EqLSO7lGcdqu31qe0Nv@4ax.com>

A copy of this was sent to chrisoc_at_ans.net (if that email address didn't require changing) On Mon, 20 Sep 1999 16:47:30 GMT, you wrote:

>
>
>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?
>

Yes.

archivelog mode (or lack thereof) only affects the databases ability to perform media recovery (from a disk failure for example)

>Chris O'Connor
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Mon Sep 20 1999 - 12:24:34 CDT