Home » RDBMS Server » Server Utilities » Multiple DB in a single sqlplus window (oracle 10.2.0.1.0 - windows XP)
Multiple DB in a single sqlplus window [message #493026] Fri, 04 February 2011 05:52 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

One of my boss told, we can connect to many databases and can access them simultaneously in a single sqlplus window?

please can any one tell me is it possible, if it is then what is the procedure.

Regards:
Muktha
Re: Multiple DB in a single sqlplus window [message #493029 is a reply to message #493026] Fri, 04 February 2011 05:54 Go to previous messageGo to next message
Littlefoot
Messages: 21624
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Via database links, true.

I can't think of any other way to be connected to different databases at the same moment from the same SQL*Plus session.

How come you didn't ask that person how to do that?
Re: Multiple DB in a single sqlplus window [message #493032 is a reply to message #493029] Fri, 04 February 2011 05:58 Go to previous messageGo to next message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because answers are better in OraFAQ!

Regards
Michel
Re: Multiple DB in a single sqlplus window [message #493047 is a reply to message #493032] Fri, 04 February 2011 07:04 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Little foot,

Yes Michel is correct, i believe in ORAFAQ.

But please show me the procedures.

Regards:
Muktha
Re: Multiple DB in a single sqlplus window [message #493050 is a reply to message #493047] Fri, 04 February 2011 07:14 Go to previous message
Michel Cadot
Messages: 67569
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
CREATE DATABASE LINK

Regards
Michel
Previous Topic: export/import from 10g/9i any other options
Next Topic: SQL Loader is missing
Goto Forum:
  


Current Time: Thu Dec 03 23:35:32 CST 2020