Hi Friends,
I am facing a problemin operating with database link.
One of the machine has Personal Oracle 8i installed. In the same machine the client of Oracle Enterprise 8i is also installed, whose server is installed on the Database server machine.
Now in the client machine, TNSNAMES.ORA files
Can you connect to the remote database using sqlplus username/password@LINKNAME
on the server where you are creating the db link?
If you can try creating the db link with the full connect string
in the using parameter
Example
Create database link LINKNAME
connect to username identified by
First you must create public database link and after that you can create
private database link which you assign to the user.
HTH,
Sonja
-Original Message-
Sent: Thursday, April 12, 2001 3:10 AM
To: Multiple recipients of list ORACLE-L
Hi there!
I'm having a problem with
AFAIK, parameter DB_DOMAIN is what appends to the database link name
(which must be DB_NAME of your remote database).
SQLWKS show parameter db_domain
NAME TYPEVALUE
-- --- --
db_domain
Did you look in TNSNAMES.ORA?
[EMAIL PROTECTED] 04/11/01 09:10PM
Hi there!
I'm having a problem with database links here.
I am on my SPEEDY database and want to create a link that points to another
database called SAM.
create database link SAM connect to user identified by pasword using
You could try setting GLOBAL_NAMES to FALSE in your init.ora file.
By default, it's set to TRUE. Once I set mine to FALSE, I was able to
create public database links easily.
- Dana
--- Michal Zaschke [EMAIL PROTECTED] wrote:
AFAIK, parameter DB_DOMAIN is what appends to the database link
I've found that it is the global_name, not the db_domain, which gets
appended to the dblink. You can check the global_name by
select * from global_name
I've had problems with dblinks if the global_name is not the same as the
db_domain. In that case, describing over a dblink fails.
HTH,
Gary
Hi there!
I'm having a problem with database links here.
I am on my SPEEDY database and want to create a link that points to another
database called SAM.
create database link SAM connect to user identified by pasword using 'SAM';
Then I try and issue that statement:
select view_name from