OraFAQ Forum: Enterprise Manager » error : create database link version 8.1.5 for NT

Home » RDBMS Server » Enterprise Manager » error : create database link version 8.1.5 for NT

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

error : create database link version 8.1.5 for NT [message #68159]

Sat, 21 December 2002 03:48

vu khanh
Messages: 1
Registered: December 2002

Junior Member

I using oracle version 8.1.5 for windowNT
I done :

SQL>CREATE DATABASE LINK PHBC
CONNECT TO phbc IDENTIFIED BY phbcttth
USING 'PHBC8'

SQL>SELECT * FROM dg_tien_bao@PHBC

error :

ORA-00911: invalid character ORA-02063: preceding str from PHBC

please help me !

thank.

Vu Khanh

Report message to a moderator

Re: error : create database link version 8.1.5 for NT [message #68160 is a reply to message #68159]

Mon, 23 December 2002 06:13

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

always
create a database link Name equal to the connect string name.
try this

CREATE DATABASE LINK PHBC8
CONNECT TO phbc IDENTIFIED BY phbcttth
USING 'PHBC8'

Report message to a moderator

Re: error : create database link version 8.1.5 for NT [message #68506 is a reply to message #68160]

Thu, 08 January 2004 01:18

Mohammad Aamir
Messages: 1
Registered: January 2004

Junior Member

PLEASE USE YOUR GLOBAL DATABASE NAME.
TO FIND THE ABOVE USE SELECT * FROM GLOBAL_NAME.

USE THE FOLLOWING CREATE SYNTAX.

CREATE DATABASE LINK SAP.PATNI.COM
CONNECT TO USERID IDENTIFIED BY PASSWORD
USING 'SAP.PATNI.COM'.

CHECK IT OUT USING THE DOS PROMPT BY TYPING TNSPING SAP.PATNI.COM.

THIS WILL SURELY WORK.

Report message to a moderator

Previous Topic:	datatype
Next Topic:	How to delete a database service?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 17:03:48 CST 2024