OraFAQ Forum: Client Tools » Connecting to another DB.

Home » Other » Client Tools » Connecting to another DB. (SQL Navigator 5.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Connecting to another DB. [message #280184]

Mon, 12 November 2007 13:51

k_sekhar_rao
Messages: 2
Registered: November 2007

Junior Member

Hi,

I want to do a select from one client of a DB to a another DB using sql navigator..
I have the details like username/password/instance name of the DB instance name. FYI...I don't want to use the option of DB link, as i have constraints for creating DB links. I want to do a select of another DB and then insert to my local DB.

Please let me know the syntax for the same. In SQL Server, we could do that, but not sure in Oracle.

thanks in advance,
Sekhar

Report message to a moderator

Re: Connecting to another DB. [message #280194 is a reply to message #280184]

Mon, 12 November 2007 14:25

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

As far as I can tell, database link is the only way to do it "live".

Another option might be taking an export of the remote schema and import it into your database; doing so, you'd avoid database link and the only thing you need is GRANT SELECT.

Report message to a moderator

Re: Connecting to another DB. [message #280205 is a reply to message #280194]

Mon, 12 November 2007 15:51

Soumen Kamilya
Messages: 128
Registered: August 2007
Location: Kolkata

Senior Member

You can also do one thing you can Export the query result into a file and then import it to you own database using sqlloader (if you do not want to run normal export/ import utility for full schema or table).
For that you have to write a normal script.

Cheers
Soumen

Report message to a moderator

Re: Connecting to another DB. [message #280265 is a reply to message #280205]

Tue, 13 November 2007 00:35

Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

OK, another step into the right direction: create a CSV file as a select from the remote database and use it as external table in your schema.

Report message to a moderator

Re: Connecting to another DB. [message #280480 is a reply to message #280265]

Tue, 13 November 2007 16:57

k_sekhar_rao
Messages: 2
Registered: November 2007

Junior Member

Thanks for your replies.
I am already using the mentioned options. Thought of knowing if there is any other way to do a select.

Report message to a moderator

Previous Topic:	SQL*PLUS generated abnormal file size.
Next Topic:	SQL* error on cline machines

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 15 23:19:18 CDT 2024