Re: Connect two bases ?

Thx Mark,

My problem is to create a real database link with : "CREATE DATABASE LINK ..."
How can I use this command ?

Thx

"Mark C. Stock" <mcstockX_at_Xenquery .com> a écrit dans le message de news:3fGdncx9IfBZ0PzcRVn-tw_at_comcast.com...
>
> "Julien" <julien_at_e20.com> wrote in message
> news:cjrhsf$22n9$1_at_biggoron.nerim.net...
> | Hi all !
> |
> | How can I simply connect two Oracle 8i databases ?
> | I try to do this in order to create view (virtual tables) from the 1st
> base
> | to the another ...
> |
> | Could you give me the procédure or a tutorial to do this ?
> |
> |
> | Thx all !
> |
> |
>
> it depends on what tool you are using -- TOAD, for instance supports
> multiple connects, SQL*Plus supports only one (but you can invoke to
> instances of SQL*Plus.
>
> likely you'll need to capture the CREATE VIEW statement from the first
> database (again, how you do that depends on the tool you are using) and
past
> the statement into whatever tool window or instance is connected to the
> second database
>
> ++ mcs
>
>
Received on Mon Oct 04 2004 - 08:34:28 CDT