Stack Overflow
Stack Overflow

Questions tagged [database-link]

108 questions
1
vote
1 answer

Java query with DB Link does not close the Db Link connection

I have a Java code that connects to Database A. Database A has DB link to Database B. Both database are oracle. I make a JPA connection to Database A Then I run a query from joining a table from DAtabase A to table in Database B Then Close…
Marco
  • 83
  • 1
  • 10
1
vote
1 answer

Creating Oracle Database Links and characters in the database link password

I'm trying to create a database link on one database, so I can view tables on another database. The password to the other database is Bl$nk-d8prd, it doesn't seem to like the "-" in the password Bl$nk-d8prd because when I don't include the "-" and…
Shaun Kinnair
  • 495
  • 2
  • 10
  • 27
1
vote
0 answers

Oracle SQL - VIEW PUSHED PREDICATE not happening when using dblink

I'm having performance issues executing the following query (Q1): select z_out.*, a_out.id from orders a_out, test z_out where a_out.id=z_out.id and a_out.created>trunc(sysdate) and rownum<10 Table orders contains millions of rows;…
zyky2000
  • 23
  • 3
1
vote
0 answers

Link existing MS-Access database to SQL Server

I have an external application that uses a MS Access database to store its data. I do not want to touch anything here, because the application works very good for me. I have now created a own application and now I need the data from the MS Access…
Aposchi8
  • 41
  • 1
  • 3
1
vote
1 answer

Designing monitoring of jobs on Oracle database

I have several Oracle databases where my in-house applications are running. Those applications use both dba_jobs and dba_scheduler_jobs. I want to write monitoring function: check_my_jobs which will be called periodically by Nagios to check if…
JiboOne
  • 1,438
  • 4
  • 22
  • 55
1
vote
1 answer

Oracle public shared database link not working for non-DBA users

I need to convert a database link that I have in Oracle from a normal public database link to a public shared database link. I ran the following as my user with DBA privileges to make the link shared: DROP PUBLIC DATABASE LINK "MYDBLINK"; CREATE…
Andrew Mairose
  • 10,615
  • 12
  • 60
  • 102
1
vote
1 answer

Should database base links in oracle be dropped/closed after you are done using them?

I have an SQL script that connects to another database using "create database link", and copies some data. Should this database base link be dropped or closed after I am done using it? (Say, assuming that I probably won't be needing it…
vicsz
  • 9,552
  • 16
  • 69
  • 101
1
vote
2 answers

Why are database links bad for security?

I heard database links are bad for organizations to use. Why is it bad for security?
Jordan Ardakanian
  • 79
  • 2
  • 6
1
vote
1 answer

use PL/SQL API through two databaselinks

There is a Oracle database (version 8) acting as PL/SQL API, providing access to different procedures and tables in that database. I have another Oracle database (version 10g) which uses these procedures and tables through database link. I upgraded…
user4252720
1
vote
1 answer

Oracle database link - connect to proxy with special characters in username

A user is granted connect by proxy via another user whose name contains special characters: CREATE USER "A-USER" IDENTIFIED BY "a"; CREATE USER foo IDENTIFIED BY "random-trash"; ALTER USER foo GRANT CONNECT THROUGH "A-USER"; Now I'm struggling to…
Kombajn zbożowy
  • 8,755
  • 3
  • 28
  • 60
1
vote
1 answer

advanced queuing for table replication to other database

So, I am trying to replicate the data in tables to another database using Advanced Queuing. I created a table on both databases: create table test ( id number(10) primary key, text varchar2(100) ); then I created the queue create type…
a.j. tawleed
  • 894
  • 1
  • 8
  • 22
1
vote
1 answer

Oracle AWS RDS database link ORA-12545

I'm trying to create a database link from my Oracle AWS RDS instance to another Oracle database outside my VPC. I created the database link this: create database link test connect to myusername identified by "mypassword" using…
phlogiston
  • 331
  • 5
  • 10
1
vote
1 answer

establish an oracle database link between databases in two hosts that don't see each other

I have access to one database server through a vpn connection and another through lan connection. from my machine I would like to copy some entries from one table into the other, like: insert into destinationtable select * from…
NotGaeL
  • 8,344
  • 5
  • 40
  • 70
1
vote
0 answers

Connect to PostgreSQL from Oracle with only PL/SQL

I am working on an Oracle script that needs data from PostgreSQL and will be run on a number of different servers. The connection to the data will remain the same, so I would like to connect to PostgreSQL without modifying the tnsnames.ora file or…
gregljohnson
  • 51
  • 5
1
vote
2 answers

PLSQL - Create DBLink inside function

I would like to create database link inside of script, and want to receive all table names from the linked database. If I am correct, I need to create database link in order to use, but Oracle does not allow me to create such thing neither inside of…
Adrian
  • 836
  • 7
  • 20
  • 44
1 2
3
4 5 6 7 8