| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: DBlink % 8i and 7
While I'm not sure about 8i, we've had problems with describing a table
across a db link from a Oracle 8 db to an Oracle 7 db. We've been told
by Oracle Support that describing across a db link is a "feature". This
means that you can use it while it works, but when it's broken, it's not
a bug. Since describing across a db link from 8 to 7 doesn't work, you
can try the alternative which is to select from dba_tab_columns across
the db link to get the same information.
HTH,
Brian
Joe Tin wrote:
>
> I have created the database link in Oracle 8i in Solaris 2.6, which is
> linked to
> Oracle 7.3.3.4 in HP-UX 10.20, using TCP/IP.
> When I tried to desc some remote tables, the following error occurs:
>
> SQL> desc country_at_etet
> ERROR:
> ORA-12663: Services required by client not available on the server
>
> 12663, 00000, "Services required by client not available on the server"
> // *Cause: Service(s) that was (were) required by the client process
> were not
> // available on the server process.
> // *Action: Configure the server with the services required by the
> client (best
> // solution) or delete the requirement from the configuration
> // file of the client (least secure).
>
> I can tnsping and sqlplus to the database in Oracle 7.3.3.4 (remote
> database).
> I can create the database link to the same remote database Oracle
> 7.3.3.4 from
> other Oracle 7 database and it works without any problem.
>
> Can somebody address what problem is?
>
> Thanks in advance
>
> Joe
> joe.tin_at_tradelink.com.hk
--
 |
 |