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

<SPAN
class=948534714-08012002>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 <FONT face=Arial
size=2>Oracle Certified Professional

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Mohan, Ross   [mailto:MohanR_at_STARS-SMI.com]Sent: Tuesday, January 08, 2002 8:40   AMTo: Multiple recipients of list ORACLE-LSubject: 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 - ProductionPL/SQL Release 8.0.5.2.0 - Production
 

  SVRMGR> connect
  internalConnected.SVRMGR> select distinct cache from   dba_tables;CACHE-----    N1 row
  selected.   

    <FONT face=Tahoma
    size=2>-----Original Message-----From: Mercadante, Thomas F     [mailto:NDATFM_at_labor.state.ny.us]Sent: Tuesday, January 08, 2002     8:10 AMTo: Multiple recipients of list     ORACLE-LSubject: 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 <FONT face=Arial
    size=2>Oracle Certified Professional     

      <FONT face=Tahoma 
      size=2>-----Original Message-----From: Jacques Kilchoer 
      [mailto:Jacques.Kilchoer_at_quest.com]Sent: Monday, January 07, 
      2002 7:35 PMTo: Multiple recipients of list 
      ORACLE-LSubject: 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----- <FONT 
      size=2>> From: Orr, Steve [<A 
      href="mailto:sorr_at_rightnow.com">mailto:sorr_at_rightnow.com] 
      > Sent: lundi, 7. janvier 2002 15:55 <FONT 
      size=2>> To: Multiple recipients of list ORACLE-L <FONT 
      size=2>> Subject: RE: Data Dictionary Wierdness <FONT 
      size=2>> > > Yeah 
      I saw that after I sent the email but it's still dumb <FONT 
      size=2>> IMHO. We can > either blame 
      achaudhr or his/her boss.  :-)  > 
      > More text from catalog.sql: <FONT 
      size=2>> Rem  achaudhr 10/25/95 - PTI: Add lpads around degree, 
      > instances, cache