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
0
votes
1 answer

Oracle: Insert over Dblink vs normal insert

As a part of a DB procedure we have the following piece of code: INSERT INTO remote_table@link_to_remote VALUES ('x','y','z'); UPDATE local_table SET process_status = '1' WHERE id = x; COMMIT; Now based on the value in process_status we have…
Jyotirmoy
  • 710
  • 6
  • 12
0
votes
1 answer

join on two databases using postgresql and dblink

I have the following databases: server_a { a_t1 (a_t1_a1, a_t1_a2); a_t2 (a_t2_a1, a_t2_a2); } server_b { b_t1 (b_t1_a1, b_t1_a2); b_t2 (b_t2_a1, b_t2_a2); } attribute 1 = serial not null (primary) attribute 2 = character…
mangusbrother
  • 3,988
  • 11
  • 51
  • 103
0
votes
1 answer

No records when using SELECT query on DBLINK in Oracle

I'm trying to move data in between two oracle databases say SOURCE_A and DEST_B. I have created a dblink (LINK_A) using TOAD on DEST_B to SOURCE_A to copy data from the tables. Dblink creation was fine, but when I used a select statement like below,…
Sirish
  • 917
  • 3
  • 14
  • 25
0
votes
2 answers

connecting form R (client) to Greenplum server

I'm trying to retrieve data from greenplum cluster into R (win client). I've tried: library("RODBC") conn <- odbcDriverConnect("DSN_name") Sql <- "select * from DB.st.country" cen_data <- sqlQuery(conn,Sql) print(cen_data) I'm getting error: 0A000…
dan
  • 15
  • 1
  • 6
0
votes
2 answers

How to check if an oracle remote database is online?

I have a db link from DB1 to DB2. I have a job that runs a procedure that uses the contents on DB2, however, I would like the procedure to first check if DB2 is online and the dblink is working, if not then stop exit the procedure. Is there a…
AYR
  • 1,139
  • 3
  • 14
  • 24
0
votes
1 answer

Stopping MV from refreshing while other database offline

I have an oracle database (DB1) which, via a db-link to DB2, refreshes materialized views every midnight using a scheduled JOB. The refresh of the MVs occurs ussing a procedure which runs over every table name in a schema and refreshed each table,…
AYR
  • 1,139
  • 3
  • 14
  • 24
0
votes
1 answer

how to select data from two tables of different databases using dblinks in oracle?

i have a table t1 in database A and another table t2 in another database B. how can we select data from them without using qualifiers directly.. just as database1.table1.something.
isaiahbabu
  • 1
  • 1
  • 1
0
votes
1 answer

update remote db using dblink_exec fails

The below statement is failing by saying syntax error, I do not see the syntax error, please help: SELECT dblink_exec( 'dbname=billing user=billing password=billing port=5432', 'insert into md.radacct values('2013-01-01…
user2594853
  • 67
  • 1
  • 9
0
votes
2 answers

SQOOP export command VS DB2 LOAD CLIENT

I have a scenario where I have copy data from hive to db2. There are two ways I can implement this. One is using sqoop export command and another is db2 load client. I need to know which is best approach with respect to performance. Please give me…
mike
  • 377
  • 1
  • 9
  • 22
0
votes
1 answer

When I imported a tinyint column from SQL Server to Oracle 10g, why did I get negative values?

I recently encountered a problem where we were running a data migration script to move data from SQL Server to Oracle 10g through an Oracle DBLink. Everything worked fine until we ran the script in our production Oracle environment. For certain…
Dan Jagnow
  • 1,175
  • 12
  • 28
0
votes
1 answer

DBlink(s) which one is safer: public link or private link?

I'm trying to think of security problems using private/public dblinks. You can see what I'm talking about in the picture below So, as shown in the picture (right option is public and left one is private) which one do you think is safe?
Sirotoshi pizdetz
  • 234
  • 2
  • 8
0
votes
1 answer

Same DBLink name used in Different Schemas of same Database - Invalidates the Procs

I have "PROD-1" db which contains 2 schemas "Schema-1", "Schema-2" I created the private dblink "DBLINK-1" in both the schemas & they are pointing to different targets. here is my configuration DB Name -> Source Schema -> Target DB -> Target Schema …
Lava
  • 1
  • 1
  • 4
0
votes
1 answer

Oracle: performance about filtering results from remote view

I have a remote database A which has a view v_myview. I am working on a local database, which has a dblink to access v_myview on databse A. If I query the view like this : select * from v_myview @ dblink ; it returns half million rows. I just…
Gary
  • 4,495
  • 13
  • 36
  • 49
0
votes
1 answer

To which DBs can I connect via DB LINK from Oracle?

To which DBs can I connect, via DB Link, form a Oracle DB? Is there a list?
John Assymptoth
  • 8,227
  • 12
  • 49
  • 68
0
votes
2 answers

Passing values to db_link_exec query in PostgreSQL

I need to insert some info I'm reading from a database into a table that belongs to a different one. I have my info in a RECORD variable, let's call it my_row. Obviously when I try SELECT dblink_exec('INSERT INTO remote_table VALUES…
andreea
  • 86
  • 1
  • 8
1 2 3
…
34
35