Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Connect two bases ?
"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:18:40 CDT