Re: Problems when using distributed SQL??

From: Christian Metzler <cme_at_magnet.at>
Date: 1996/01/03
Message-ID: <3528261630.11884966_at_magnet.at>#1/1

Maybe you forgot to grant select privileges on table2. "GRANT SELECT ON TABLE2 TO PUBLIC"

If this doesnt help check your SQL*NET configuration files. Make sure you can connect to the remote machine via sqlplus. It looks that you are using SQL*NET V1.xx. If possible use SQL*NET V2.xx. Networking is much easier than.

The distributed Option is a separately priced product. If it is installed then sqlplus should come up with: " ORACLE 7.xxx .......Server Production Release with the distributed option installed"

cme_at_magnet.at
Vienna/Austria/Europe Received on Wed Jan 03 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Al Sabawi,sabawi_at_ibm.net: "Re: Problems when using distributed SQL??"
Previous message: Thomas J Kyte: "Re: Changing Of Password In Oracle Application"
Maybe in reply to: sabawi_at_ibm.net: "Problems when using distributed SQL??"
Next in thread: Al Sabawi,sabawi_at_ibm.net: "Re: Problems when using distributed SQL??"
Reply: Al Sabawi,sabawi_at_ibm.net: "Re: Problems when using distributed SQL??"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message