RE: Data Dictionary Wierdness a.k.a. Memory Serveth Not

[Mohan, Ross]

Title: RE: Data Dictionary Wierdness

Oops!  I meant it helpfully, not meanly! Apologies!

-----Original Message-----
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 9:56 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Data Dictionary Wierdness a.k.a. Memory Serveth Not

ok.  so my memory is not-so-good.  thanks for pointing it out to thousands of my best friends in a public forum.  {:0

 

thanks Ross!  :)

 

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Mohan, Ross [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 8:40 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Data Dictionary Wierdness a.k.a. Memory Serveth Not

instnd01#test8> svrmgrl

 

Oracle Server Manager Release 3.0.5.0.0 - Production

 

(c) Copyright 1997, Oracle Corporation.  All Rights Reserved.

 

Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
PL/SQL Release 8.0.5.2.0 - Production

 

SVRMGR> connect internal
Connected.
SVRMGR> select distinct cache from dba_tables;
CACHE
-----
    N
1 row selected.

-----Original Message-----
From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 08, 2002 8:10 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: Data Dictionary Wierdness

If my memory serves me correctly, didn't this value used to be 'CACHE' and NULL?  That would explain the 5 char length.  Anybody have 805 available to test it?

 

Tom Mercadante
Oracle Certified Professional

-----Original Message-----
From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 07, 2002 7:35 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Data Dictionary Wierdness

Maybe some of the database engine source code is written in COBOL and needs those blank spaces at the beginning for an accurate comparison? Or are you calling achaudhr a chowderhead?  :-)

If it's any consolation, DBA_LOBS.CACHE is 'YES' or 'NO'.

> -----Original Message-----
> From: Orr, Steve [mailto:[EMAIL PROTECTED]]
> Sent: lundi, 7. janvier 2002 15:55
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Data Dictionary Wierdness
>
>
> Yeah I saw that after I sent the email but it's still dumb
> IMHO. We can
> either blame achaudhr or his/her boss.  :-) 
>
> More text from catalog.sql:
> Rem  achaudhr 10/25/95 - PTI: Add lpads around degree,
> instances, cache