Re: "desc tab_name@db_link" doesn't work from 8.0 towards 7.3

I have a db link as well, they are both on oracle 8 but the desc doesn't seem to work either. It seems that desc assumes that the table is in the same db.

What you can do is...

 select column_name, decode(nullable,'Y','','NOT NULL') "Null?",  data_type type, data_length length
 from user_tab_columns_at_DB_LINK
 where table_name = 'CUSTOMER'

Should *almost* replicate the desc function

Mark

monsri_at_my-deja.com wrote in message <7kva7s$sjf$1_at_nnrp1.deja.com>...
>Hi here,
>Just a simple question: we got 2 Oracle instances running
>here, one in 7.3.4 and the other in 8.0.4.
>When we type "desc tab_name_at_db_link" from the 8.0 instance
>towards the 7 one, we get the following message:
>> ERROR:
>> ORA-12663: Services required by client not available on the server
>
>*_But the usual SQL statements work fine_*
>
>It obviously comes from dictionaries discrepancies regarding
>the DESCRIBE SQL*Plus function, between the 2 instances
>versions, but does anybody know any means to make a
>DESCRIBE work anyway from an 8 instance towards a 7 ??
>
>Thanks !
>Regards,
>Spendius
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Fri Jun 25 1999 - 03:00:43 CDT