1.I have two unix servers .I want to establish a database link between the 2 databases on two unix servers and start
working with database.
2. Tell me something about the multiple instances and h...
http://www.experts-exchange.com/Database/Oracle/Q_10130742.html
Zones:
OracleDate Answered: 05/07/1999 Grade: C Views: 0
When I create database link dblink and try to use it,
select * from scott.emp@dblink, I get the error:
ORA-12154: TNS:could not resolve service name.
Sometimes the mail domain instead of network...
http://www.experts-exchange.com/Database/Oracle/Q_20287811.html
Zones:
OracleDate Answered: 04/19/2002 Grade: A Views: 5
Hello, I need to make a query from different tables in 2 different DB. Is a simply query using joins from table A in DB_1 and table X in DB_2.
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20491222.html
Guys,
SOURCE
ZIP1 VARCHAR2(20)
ZIP2 VARCHAR2(20)
DTM DATE
LOOKUP
CD VARCHAR2(20)
LAT NUMBER(7,4)
LONG NUMBER(7,4)
DESTINATION
ORILAT NUMBER(7,4) NOT NULL
ORILONG NUMBER(7,4) ...
http://www.experts-exchange.com/Database/Oracle/Q_20645995.html
Zones:
OracleDate Answered: 06/17/2003 Grade: A Views: 0
hi, i'm recently installed a Oracle9i release 9.2.0.1.0 on a Sun 280R Server, i'm trying to describe a table on other solaris server with oracle 7.3.4 via dblink, but i have a ORA-01002 error. When...
http://www.experts-exchange.com/Database/Oracle/Q_20767679.html
Zones:
OracleDate Answered: 10/15/2003 Grade: A Views: 14
OK. I am trying to get a DBLink working The schema I want to link to is username: abc; password: def. I can login to the account without problems from SQLPlus. I use TNSNames.ora and I setup WO...
http://www.experts-exchange.com/Database/Oracle/Q_20843867.html
Zones:
OracleDate Answered: 01/07/2004 Grade: A Views: 32
Ok the problem I have is as follows:
We have a system (from an external supplier) running MS SQL Server that has a view on it which we have been given access to and need to use via an ODBC link....
http://www.experts-exchange.com/Database/Oracle/Q_21049048.html
Zones:
OracleDate Answered: 08/03/2004 Grade: B Views: 0
We had a Database Link Set up to access an external database on a server I have no control over through our database (to run queries). This has stopped working within the last day or so, the code ...
http://www.experts-exchange.com/Database/Oracle/Q_21073935.html
Zones:
OracleDate Answered: 09/21/2004 Grade: B Views: 9
We are going to use a dblink to refresh a onsite database from an offsite server.(we own both the servers)
I couldnt find any articles on the web regarding the impacts of using a dblink on a serv...
http://www.experts-exchange.com/Database/Oracle/Product_Info/Q_21911811.html
oracle db 10g2:
I have 3 databases, I will call them: db1,db2,db3
o I created dblinks using the same ddl on db2 and db3 that allow me to access db1.
o On db2 and db3 I am using a user with the...
http://www.experts-exchange.com/Database/Oracle/10.x/Q_22500089.html
