Stack Overflow
Stack Overflow

Questions tagged [dblink]

An object or module that enables access to a remote database.

In Oracle a database link is a schema-level object that enables users to access objects on a remote database. It is possible to create a database link to access a non-Oracle database.

In PostgreSQL dblink is a module, which enables connections to other PostgreSQL databases, from within a session.

Questions tagged should also be tagged with the appropriate RDBMS.

523 questions
2
votes
1 answer

Is it possible to temporarily disable an Oracle database link

Here is the situation. We have an Oracle 11g database where one schema user has a private database link to a remote database. When the user initiates a certain process, it pulls a large amount of data across and slows down the other applications. We…
JPHether
  • 21
  • 1
  • 3
2
votes
2 answers

How can you do an update to a table in another database using postgres dblink?

The query that has to be executed is as simple as below - Update employee set is_done=true; The table that I want to update is only present in another database. I have been using these kinds of dblink queries. INSERT Into mytable select * from…
Tisha
  • 827
  • 3
  • 11
  • 34
2
votes
2 answers

Trigger to insert rows in remote database after deletion

I have created a trigger that works like this: After deleting data from table flux_tresorerie_historique it insert this row in the table flux_tresorerie_historique that is located in another database archive I use dblink to insert data in the remote…
hacene abdessamed
  • 559
  • 6
  • 22
2
votes
1 answer

ORA-02070: database does not support in this context Via DB LINK

I have a View and want to insert this via DB Link. But it's give error "ORA-02070: database does not support in this context". How can I solve this error ? CREATE OR REPLACE FORCE VIEW V_TEST ( OBJECT_ID, SEQUENCE, SCHEMA_NAME, …
Chicharito
  • 1,450
  • 8
  • 31
  • 49
2
votes
1 answer

synchronizing two tables in postgres using DBlink

I want to have two synchronized DB in two different servers (server1 and server2) so: table1 in server1 updates table1 in server2 when table1 in server1 changes and table1 in server2 updates table1 in server1 when table1 in…
user2957058
  • 270
  • 5
  • 16
2
votes
1 answer

how do I use postgres dblink in hibernate?

I want to use postgres dblink from hibernate. Is it possible to open, execute and close dblink queries from hibernate.If yes then is there any example?
Madhusmita Mohapatra
  • 21
  • 1
2
votes
0 answers

How to query a Db link with usn/pwd provided at runtime?

Oracle Database. I have this scenario where we were using a DBLINK (type Current User Database Link ) on DB1 to DB2 which simply means the credentials user1/password1 used on the DB1 is valid for user1 on DB2. It just so happened now that…
Sadique Khan
  • 161
  • 3
  • 13
2
votes
2 answers

Skipping unusable indexes causes dblink error

Every once and a while when I'm executing the following statement: alter session set skip_unusable_indexes=true; I'm getting the following error: ORA-03135: connection lost contact ORA-02063: preceding line from my_dblink What does skipping…
Yuval Cohen
  • 19
  • 2
2
votes
1 answer

Strange behaviour, results from linked DB

Running this query on Toad select * from customer@linkedDb where "CustomerNumber"=1 Gets a single row results, however select * from customer@linkedDb where "CustomerNumber"=(select 1 from dual) Still returns a single row, but almost every…
Denzil Newman
  • 393
  • 1
  • 11
2
votes
1 answer

PostgreSQL: there is no parameter $1 in dblink query

Im currently using PostgreSQL 9.3 and Im trying to work on this function which connects to another database (esms) and the result of the said function will be compared and used in another function within another database (seis). CREATE OR REPLACE…
Oh Cathee
  • 23
  • 1
  • 3
2
votes
0 answers

Is it possible to edit a table via dblink in APEX?

I've created a form in the APEX and I need to edit a table via dblink, which is already created . So, when I ask to show me a data in this remoute table- it's work fine, but when I'm trying to edit data, I get the error: "Table or view…
Анна
  • 21
  • 3
2
votes
1 answer

Display tables from a DB linked Database in SQL Developer

I have a normal Oracle schema where I can see all the tables and if you click on one, it pops up a new tab with the contents in it, perfect. I also have a Database that is connected via DbLink, and I can see all the tables when I execute a…
user1772250
  • 319
  • 5
  • 15
2
votes
1 answer

is a a dblink allowed in a J2EE distributed transaction?

I am writing a PL/SQL procedure (Oracle) that will be called by a J2EE program. This J2EE program has started a distributed transaction and my PL/SQL procedure will be part of this transaction. I wonder if it is allowed to use a dblink inside my…
jmb
  • 129
  • 11
2
votes
1 answer

Pushing data from Postgres 9.2 to a remote database

I've used dblink several times in the past to pull information from a remote database into a local one. However, I find myself wanting to do the opposite. I want to PUSH from local to a remote. Per the docs, I know you can do a: SELECT…
David S
  • 12,967
  • 12
  • 55
  • 93
2
votes
1 answer

Managing DB Links inside a view Oracle PL/SQL

Lets say you have six oracle database servers which are basically identical, but represent different factories. For easier reporting, we could make a nice big view on a seventh server that selects in via @dblink1-6. Works fine 99% of the time. …
user3182970
  • 25
  • 3
1 2 3
…
34 35