| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Some Oracle8 Questions
On Fri, 03 Oct 1997 20:19:41 GMT, cord_at_ragesoft.NOSPAMMERZ.com (Robert Cordingley) wrote:
>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.
>
its sqlplus. the 8.0.3 sqlplus describe is somewhat broken.
desc won't follow synonyms right now. its fixed in 8.0.4.
>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
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Bethesda MD
http://govt.us.oracle.com/ -- downloadable utilities
 |
 |