OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Problems DBLINK (Oracle 11g)

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

Problems DBLINK [message #590352]

Wed, 17 July 2013 08:40

zarta
Messages: 5
Registered: March 2012

Junior Member

Hello:

I'm try to connect to databases with DBLINK. It works, but I drop the dblink to do it again in the final server. The problem that I now is that there is not any DBLINK in my database but I can see the data of the other database (with select 1 from DATABASE.TABLE)

How i can solvent this problem? Is my database saving the data of the other database without de DBLINK?

Thanks!!

Report message to a moderator

Re: Problems DBLINK [message #590353 is a reply to message #590352]

Wed, 17 July 2013 08:44

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

>I can see the data of the other database (with select 1 from DATABASE.TABLE)
use COPY & PASTE so we can see what you report

Report message to a moderator

Re: Problems DBLINK [message #590363 is a reply to message #590353]

Wed, 17 July 2013 08:57

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

database.table?

You don't put DB names in front of table names in oracle. You put schema names in front of table names.

Report message to a moderator

Re: Problems DBLINK [message #590364 is a reply to message #590352]

Wed, 17 July 2013 08:58

Michel Cadot
Messages: 68764
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The syntax "select 1 from DATABASE.TABLE" means you don't understand the meaning of database in Oracle.
It actually is "select 1 from SCHEMA.TABLE" and it does not need any database link.

If you want to access a table into another database the syntax is "select 1 from TABLE@DATABASE_LINK".

Regards
Michel

Report message to a moderator

Re: Problems DBLINK [message #590387 is a reply to message #590364]

Wed, 17 July 2013 10:03

zarta
Messages: 5
Registered: March 2012

Junior Member

Thanks!! I now is ok.

Report message to a moderator

Previous Topic:	geometric data from text to table and wrong ctl upload into table (2 threads merged by bb)
Next Topic:	Multithreading not working with direct path load

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jul 31 12:31:21 CDT 2025