We had a similar situation where the inserts with a subquery over a DB link are not working. # LISTENER.ORA Network Configuration File: c:\Oracle\Ora81\network\admin\listener.ora
![oracle database link oracle database link](https://www.relationaldbdesign.com/network-topology/module4/images/databaselink1.gif)
(ADDRESS = (PROTOCOL = TCP)(HOST = CPQD050068)(PORT = 1521))Ĭ:\Oracle\Ora81\network\ADMIN>type listener.ora (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) # TNSNAMES.ORA Network Configuration File: c:\Oracle\Ora81\network\admin\tnsnames.oraĮXTPROC_CONNECTION_.BR = NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME)Ĭ:\Oracle\Ora81\network\ADMIN>type tnsnames.ora
![oracle database link oracle database link](https://www.ktexperts.com/wp-content/uploads/2019/01/1a.jpg)
# Generated by Oracle configuration tools. # SQLNET.ORA Network Configuration File: c:\Oracle\Ora81\network\admin\sqlnet.ora ORA-12535: TNS:operation timed sqlnet.ora ORA-12535: TNS:operation timed alter session set global_names = true ORA-12535: TNS:operation timed alter session set global_names = false PL/SQL procedure successfully select * from select * from * from at line 1: Tom, What is exec print_table ( 'select * from user_db_links' ) I worked around the tnsnames.ora file in various ways but could not succeed. ORA-02085: database link DISPDC1.world connects to ORACLE.WORLD SQL> create table t12 as select * from table t12 as select * from at line 1: Then,as an alternative, I tried to cretae a database link as below:Ģ connect to dewadba identified by dewadba98 SQL> CONNECT - connected to remote database
![oracle database link oracle database link](https://i1.wp.com/laurenthinoul.com/wp-content/uploads/2016/07/RebelLabs-SQL-cheat-sheet.png)
ORA-02019: connection description for remote database not found SQL> CREATE TABLE T12 AS SELECT * FROM TABLE T12 AS SELECT * FROM at line 1: SQL> CONNECT DEWADBA/DEWADBA - Connected to local database My problem description is detailed below:
ORACLE DATABASE LINK PASSWORD
For example I create database link ora8idevĭatabase link select * from do not have to use the connect to and identified by clauses, if I do not, it will use the login and password of the currently connected user to connect to the remote database.
ORACLE DATABASE LINK MANUAL
PL/SQL Release 8.1.5.0.0 - you have that setup, you log into the database (the local database - the one you want to create the database link in to connect to the OTHER database) and issue the create database link command (see the sql reference manual for complete syntax). Oracle8i Enterprise Edition Release 8.1.5.0.0 - Production Sqlplus the machine the server you want to create the database link ON works - you've gotten the first step done. You need a tnsnames entry in your tnsnames.ora on the server.