Stack Overflow
Stack Overflow

Questions tagged [database-link]

108 questions
3
votes
2 answers

Can't create Database Link to remote DB in Oracle-DB

We have a CRM system in our company, which uses an Oracle 11g database. It is developed by a third party vendor. We do not have access to the server which runs the CRM system. But nevertheless, we have working DBA login data available to us (SYS…
user748261
  • 151
  • 1
  • 2
  • 6
3
votes
2 answers

ORACLE/ASP.NET: ORA-2020 - Too many database links... what's causing this?

Here's the scenario... We have an internal website that is running the latest version of the ODAC (Oracle Client). It opens database connections, runs a stored procedure or packaged method, then disconnects. Connection pooling is turned on, and we…
jlrolin
  • 1,604
  • 9
  • 38
  • 67
2
votes
2 answers

Transferring MySQL Database Link Across Multiple PHP Pages

Are there any tricks to transferring and/or sharing the Resource Links across multiple PHP pages? I do not want the server to continue connecting to the database just to obtain another link to the same user in the same database. Remember that the…
Paradius
  • 7,949
  • 11
  • 32
  • 38
2
votes
2 answers

Accessing individual column using database link

I am new to Oracle world. I have recently created a Database Link in Oracle to fetch the data from SQL Server and I am able to fetch the data. SELECT * FROM emp@dblink The above query fetching all the rows from "emp" table hosted on SQL Server. But…
SumanKumar
  • 344
  • 5
  • 19
2
votes
0 answers

Oracle Load from other Database Scenarios

I am new in oracle (about 6 month ), I manage 2 Database, let say DB_A and DB_B, both is Oracle database, DB_A have Public database link to DB_B, this dbLink is used in package function to get data from DB_B and write it's data to a table…
amincahcepu
  • 43
  • 6
2
votes
0 answers

Connect to SQL Server from Oracle 10g

I have Oracle 10 g and SQL Server 2014. SQL Server host name is server8.as.local, login - test2, passw - test2, DB - Northwind That's what I did. tnsnames.ora: hsodbc = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.1.13)…
Rizvan Jalalov
  • 21
  • 4
2
votes
1 answer

Oracle DB link - where clause evaluation

i have a DB2 data source and an Oracle 12c target. The Oracle has a DB link to the DB2 defined which is working in general. Now i have a huge table in the DB2 which has a timestamp column (lets call it ROW_CHANGED) for row changes. I want to…
Martin K.
  • 1,050
  • 8
  • 19
2
votes
1 answer

How do I close the cursor created in a database link(ORA-02080)?

I perform the following sequence of steps(step-wise using F-9) in Oracle SQL Developer: create database link mydb connect to my_schema identified by mypwd using 'connection1'; select * from users where id = 1; rollback; ALTER SESSION CLOSE…
Roland
  • 7,525
  • 13
  • 61
  • 124
2
votes
1 answer

How to list tables from accessible via database links?

I have an access to a database, and sure I can get all tables/columns accessible for me just using: select * from ALL_TAB_COLUMNS I can also access some tables using "@", as I understand a database link mechanism, like this: select * from…
Pavel Fomin
  • 23
  • 1
  • 4
2
votes
1 answer

Create user through procedure on another database via database link

I have created user on another database using database link and stored procedure but facing problem while grant permission to the new created users. Check below code: CREATE OR replace PROCEDURE Hostname10 (user_name IN VARCHAR2, …
Rahul Joshi
  • 31
  • 1
  • 9
2
votes
0 answers

Invalid identifier on database link when add new column in table

I have 2 database DB1 with user a with ip address 192.168.10.5 DB2 with user b with ip address 192.168.10.6 in DB2, I have existing table called tb_r_system I create database link in DB1 to get table tb_r_system in DB2 CREATE DATABASE LINK…
nirwan
  • 51
  • 1
  • 6
1
vote
1 answer

Can you create dblink for the same database you are connected?

I know this is kind of weird but I would just like to know how this was being setup. There are two database and they are the same (one is mirror from the other). The first db is named "reportsdw" and the other one is "reportsdwx". I tried to…
mysticfalls
  • 445
  • 5
  • 17
  • 28
1
vote
1 answer

Returning Multiple Values from Oracle Function over Database Link

I have two oracle databases: A and B. On database A, I have a function which returns user defined type: create or replace type my_type as object ( id number, f2 varchar2(4000), f3 varchar2(4000), f4 varchar2(4000) …
JiboOne
  • 1,438
  • 4
  • 22
  • 55
1
vote
4 answers

How To Prevent Database Links to Same Database in Oracle

My Main objective is to write a PLSQL Procedure to create database links when host, port, service, username and password is given. There I need to block creation of database links to same database. How can I block the creation of database links to…
JEJC_JACALK
  • 409
  • 1
  • 5
  • 13
1
vote
0 answers

How to proxy into another database user in Oracle database link, with kerberised authentication

Background: 2 Database hosts(with users): DB1(UserA), DB2(UserA, UserB) A database link from DB1, UserA, created and works fine with the following SQL CREATE DATABASE LINK "DB_LINK" USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
Edison Lo
  • 476
  • 8
  • 25
1
2
3 4 5 6 7 8