Home » RDBMS Server » Server Utilities » Problems DBLINK (Oracle 11g)
Problems DBLINK [message #590352] Wed, 17 July 2013 08:40 Go to next message
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!!
Re: Problems DBLINK [message #590353 is a reply to message #590352] Wed, 17 July 2013 08:44 Go to previous messageGo to next message
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
Re: Problems DBLINK [message #590363 is a reply to message #590353] Wed, 17 July 2013 08:57 Go to previous messageGo to next message
cookiemonster
Messages: 13917
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.
Re: Problems DBLINK [message #590364 is a reply to message #590352] Wed, 17 July 2013 08:58 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Problems DBLINK [message #590387 is a reply to message #590364] Wed, 17 July 2013 10:03 Go to previous message
zarta
Messages: 5
Registered: March 2012
Junior Member
Thanks!! I now is ok.

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:
  


Current Time: Fri Mar 29 02:35:05 CDT 2024