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

Currently the ROWID is has the format 'BBBBBBBB.RRRR.FFFF' where BBBBBBBB is the block number, RRRR is the slot(row) number, and FFFF is a file number. For the sake of this document, this format will be called the restricted format. The new Oracle8 ROWID, will be 10 bytes long (compared to existing rowid of 6 bytes) and will contain the data object number, the DBA (data block
address) and the row number of the row (this format will be referred to as the extended format).

It is possible for a pre-V8 client to access a V8 database and visa versa. Binary and character values of the pseudo column ROWID and of columns
of type ROWID that are returned by a pre-V8 database to a V8 database are always restricted because the pre-V8 system will not know about the extended rowid.

Most of the ROWID functionality works for accessing a pre-V8 server. A supplied package (DBMS_ROWID) can be used for interpreting ROWID contents. If an Oracle8 database is being accessed from a pre-V8 client, the server will return the ROWID in the extended format. Therefore, you will not be able to interpret the rowid contents or store ROWIDs in a user column of ROWID type without using the DBMS_ROWID package.

Regards

<monsri_at_my-deja.com> wrote in message news:7kvatn$tqm$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 - 14:13:34 CDT