Describe on database linked Table ok, but it did not work with synonym

From: Karl R. <kreitsch_at_zdnetmail.com>
Date: Wed, 15 Dec 1999 07:38:27 -0800
Message-ID: <11f733ec.a5379085@usw-ex0102-012.remarq.com>

Hello!
Here some Details for Environment

OS	NT 4.0 SP3
DB	ORACLE 8.0.5.2.0

init.ORA.GLOBAL_NAMES=FALSE

Local Database TDW1
Far Database TDA1

TDW1: I create a DatasbaseLink, the far User ACHMS_READ has REad-Access to far ACMS-Objects :

	CREATE  DATABASE LINK TDA1.WORLD_at_ACMS_READ
		CONNECT TO ACMS_READ
		IDENTIFIED BY ACMS_READ
		USING 'TDA1.WORLD'
		;
	

Describing Works fine!!

	SQL> desc acms.acms_header_at_TDA1.WORLD_at_ACMS_READ;
	 Name                            Null?    Type
	 ------------------------------- -------- ----
	 AH_DATEI_NR                     NOT NULL NUMBER(20)
	 AH_STATUS                       NOT NULL VARCHAR2(2)
	 AH_ABGEBEND                     NOT NULL VARCHAR2(20)
	 AH_EMPFANGEND                   NOT NULL VARCHAR2(20)
	 AH_BEZEICHNUNG                           VARCHAR2(100)
	 AH_DATE_STATUS_10                        DATE
	 AH_DATE_STATUS_20                        DATE
	 AH_DATE_STATUS_30                        DATE
	 AH_DATE_STATUS_40                        DATE
	 AH_DATE_STATUS_99                        DATE
	 AH_FUNKTION                              VARCHAR2(20)
	 AH_PROGRAMM                              VARCHAR2(20)
	 AH_SATZANLAGEDATUM                       DATE

Now I create a synonym for the far Table:

CREATE SYNONYM ACMS_HEADER FOR acms.acms_header_at_TDA1.WORLD_at_ACMS_READ;

But Describing fails ... why??!!

	SQL> desc ACMS_HEADER;
	ERROR:
	ORA-02019: connection description for remote database not found

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!

Received on Wed Dec 15 1999 - 09:38:27 CST