Stack Overflow
Stack Overflow

Questions tagged [database-link]

108 questions
0
votes
2 answers

Network Outage Causes Stored Procedure Querying Across DB Link to Hang Forever

A number of stored procedures I support query remote databases over a WAN. The network occasionally goes down, but the worst that ever happened was the procedures failed and would have to be restarted. The last couple weeks it's taken a sinister…
Jeff
  • 8,020
  • 34
  • 99
  • 157
0
votes
1 answer

Dynamic Query Error in PLSQL

I am trying to execute this procedure: CREATE OR REPLACE PROCEDURE SP_DYNAMIC AS tbl_list VARCHAR2(2000); DBLINK VARCHAR2(100); V_SQL VARCHAR2(1000); BEGIN DBLINK := 'SOME_LINK'; V_SQL := 'SELECT table_name,table_owner FROM…
Saroj
  • 71
  • 2
  • 11
0
votes
3 answers

How to design this database layout?

I am working on a site similar to Craigslist where users can make postings and sell items in different cities. One difference between my site and Craigslist will be you will be able to search by zip code instead of having all of the cities listed on…
three3
  • 2,756
  • 14
  • 57
  • 85
0
votes
1 answer

Create user through procedure on another database via database link

I'd like to create users through procedure on another database via database link.I am getting error while executing procedure. Here are the code which i used. create or REPLACE PROCEDURE hostname (host_name in varchar2,user_name in VARCHAR2,…
Rahul Joshi
  • 31
  • 1
  • 9
0
votes
1 answer

Manually insert resultset into query

I have one DB with managers and its dependent users. And the other db on other server, with some other information about users. I want to query second DB and get data grouped by managers. One solution for this is to loop through result from db2 and…
dzona
  • 3,323
  • 3
  • 31
  • 47
0
votes
1 answer

select from db link inside package body

When creating a package body i cannot have a select from another db link inside the package body? I dont know the value of the dblink name from before therefore Create or replace package body sth as procedure getvalues(linkname in char) is …
George Georgiou
  • 455
  • 2
  • 14
  • 27
0
votes
1 answer

Oracle SQL parse whole script over Database Link instead of per Table@MY_DB_LINK

I have a complex sql script. All tables are on database(DB) 'A', when i run the script there i get the results after 50 minutes. I have an ETL tool which runs the script on DB 'A' and fills a table on DB 'B' with the results. The ETL tool is being…
user3328765
  • 1
0
votes
1 answer

Oracle after update trigger creating public database link

I have an error: 'ORA-04092: cannot COMMIT in a trigger' when trying to execute ddl command in one simple oracle after update trigger. Trigger needs to create public database link after one field in column is updated. Here is the source: create or…
Ivan Tadic
  • 143
  • 2
  • 9
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

Creating an oracle databe link - ora-12154 error

I am trying to create an oracle DB-Link like so: CREATE DATABASE LINK test5 CONNECT TO bla IDENTIFIED BY bla USING 'bli'; select * from dual@test5 In my tnsname.ora: NPGPROD = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST =…
susparsy
  • 1,016
  • 5
  • 22
  • 38
0
votes
2 answers

Creating a DB link if not created inside a stored procedure

I'm trying to code a stored procedure in Oracle. I don't have a ton of experience with it and I'm running to an issue. The end goal of the procedure is to take data from one DB and put it into another in a different form. I have most of the…
user940769
  • 53
  • 2
  • 9
0
votes
1 answer

Is there any other way to query two databases with Oracle SQL Developer without creating a database link

I'm trying to code a query that needs to access two separate database connections and cant figure out how. I have my .sql file connected to connection: A, but i need to join information from connection: b to get all the information I need. I cant…
user2166098
  • 11
0
votes
1 answer

on using oracle database link theres an error "ORA-12154 TNS Could not resolve the connect identifier specified"

I'm trying to define a database link on oracle 10.2 with connection identifier that throws the error in the question header. I have the connection identifier (service name) in my tnsnames.ora file. I can connect with sqlplus using this service name.…
gold finger
  • 51
  • 1
  • 2
  • 3
0
votes
1 answer

Remote DataBase Links

My team and I are developing a program for a bank and need to synchronize data with an existing system that is deployed on the internal network of the bank's clients. Any update made to the data in our system should be replicated to their system…
HariShankar
  • 859
  • 1
  • 10
  • 21
-1
votes
1 answer

Local database docker to AWS database in VPN

i'm a beginner to Docker, hope everyone can help, much appreciated. I downloaded a docker image from my company repository and i managed to create a container in my local machine from the image, let's named it mydb. It is created through command…
akira
  • 51
  • 6
1 2 3 4 5 6
7
8