Home » RDBMS Server » Enterprise Manager » error : create database link version 8.1.5 for NT
error : create database link version 8.1.5 for NT [message #68159] Sat, 21 December 2002 03:48 Go to next message
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
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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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'

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 Go to previous message
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.
Previous Topic: datatype
Next Topic: How to delete a database service?
Goto Forum:
  


Current Time: Thu Mar 28 05:37:09 CDT 2024