Nov 7, 2012 · How to create a DB link between two Oracle instances. Let's say A and B are two instances. I want to access the data in instance B from the instance A.

A public DB link "DB_LINK" located in "SCHEMA_B" The DB_LINK is working when using the DB user "SCHEMA_B" directly Question: When logged on as "MYUSER", what is the correct …

Nov 10, 2020 · I would like to know if it exists an Oracle command to know if a DB-LINK (name: myBDLink) is used somewhere in a DB and how to display the objects (views,materialized …

Oct 5, 2010 · I am used to Oracle and to create a dblink in my schema and then access to a remote database like this: mytable@myremotedb, is there anyway do to the same with …

Oct 3, 2010 · I have a main database with only setup data at the headquarter and several databases at different branches.I created a database link for each branch server. In some …

Oct 8, 2010 · If you create the database link in that new user's schema, you could create read-only views using the link which your test user could access without exposing the database link …

Even if you run create database link your_user.link3 using "db_alias" it's owner will be SYS. Possible hacks are connect as another user (you may add conn into SQL*Plus script if you …

Apr 10, 2015 · Basically I have a Database link (Oracle) called mylink.domain, in this link we can access foundation information like name of them members and other general information. I …

Feb 20, 2025 · if it's a public link you have to say drop public database link xyz instead of just drop database link xyz. If its private, you have to be logged in as the link owner to drop it - you …

Dec 16, 2011 · db_link are from db server to db server, not from client to server; so please make sure your both database servers have correct tns entries for service. tnsnames.ora on …