Re: join view with/without archiving on?

From: Thomas Kyte <tkyte_at_us.oracle.com>
Date: Tue, 21 Sep 1999 09:39:34 -0400
Message-ID: <e4rnN6XsDzO3cFtohauI41YwmRg8@4ax.com>

A copy of this was sent to oracle_rahul_at_my-deja.com (if that email address didn't require changing) On Tue, 21 Sep 1999 10:31:31 GMT, you wrote:

>HELLO
>
>HI R U SURE U CAN CREATE TNE DATABASE LINK BETWEEN THE TWO DATABASE ONE
>IS IN ARCHIVELOG AND ANOTHER IS IN NOARCHIVELOG.
>

Yes I am:

tkyte_at_ORACLE8I.US.ORACLE.COM> create database link ORA8I.world   2 connect to tkyte identified by tkyte using 'ORA8I.world';

Database link created.

tkyte_at_ORACLE8I.US.ORACLE.COM> select log_mode from v$database;

LOG_MODE

---

NOARCHIVELOG tkyte_at_ORACLE8I.US.ORACLE.COM> select log_mode from v$database_at_ora8i.world;

LOG_MODE

---

ARCHIVELOG tkyte_at_ORACLE8I.US.ORACLE.COM> select * from   2 ( select log_mode from v$database ) , ( select log_mode from v$database_at_ora8i.world );

LOG_MODE LOG_MODE
------------ ------------
NOARCHIVELOG ARCHIVELOG A join between 2 databases, one in archive log mode and the other not.

>
>RAHUL
>ESSAR CELLPHONE LTD
>ORACLE DBA
>
>
>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 Tue Sep 21 1999 - 08:39:34 CDT