Re: Some Oracle8 Questions

Mildly tangental to Greg's question:

I've experienced problems with the sql*plus describe command in Oracle8. Specifically, when I try to describe *ANY* V$ table, Oracle8 claims it doesn't exist. If I describe sys.v$_session it works, but describing v$session fails. Is this a bug or a misfeature? I've checked it out, and it's endemic to public synonyms...even if you're the owner of the base table. I've been to lazy to try using OCI or dbms_sql to describe a public synonym, but I hope like hell it's just sql*plus that's broken.

Robert

PS: I haven't ruled out the possibility of a hosed up install either.

On Thu, 02 Oct 1997 16:56:43 GMT, tkyte_at_us.oracle.com (Thomas Kyte) wrote:
>On 2 Oct 1997 13:28:16 GMT, "Greg Westendorf"
><westendorf_at_nospamcp-consulting.com> wrote:
>
>>Hi,
>>I'm looking into Oracle8 compatibility with our current Oracle 7.3 for NT
>>database. I have a few questions that I'm hoping someone can answer. I
>>read about LOBs (Large Binary Objects) and wondered if Oracle8 still
>>supports the Long Raw datatype. We have several tables using Long Raw and
>
>Yes they are still supported, no datatypes have been removed. LONGS and LONG
>RAWS are still supported in the same manner as before.
>
>>a change in that data type translates to a change in the VB code.
>>Also, is there any problem with Net8 connectivity? Is it compatible with
>>16-bit VB/Access programs?
>>In general are there any pitfalls or horror stories I should know about?
>>
>
>Net8 is backwards compatible with sqlnet2. The Net8 listener will accept
>sql*net 2 client connections.
>
>>TIA
>>greg
>
>
>Thomas Kyte
>tkyte_at_us.oracle.com
>Oracle Government
>Bethesda MD
>
>http://govt.us.oracle.com/ -- downloadable utilities
>
>----------------------------------------------------------------------------
>Opinions are mine and do not necessarily reflect those of Oracle Corporation
Received on Fri Oct 03 1997 - 00:00:00 CDT