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

<SPAN
class=983503915-08012002>Oops!  I meant it helpfully, not meanly! Apologies!

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Mercadante, Thomas F   [mailto:NDATFM_at_labor.state.ny.us]Sent: Tuesday, January 08, 2002   9:56 AMTo: Multiple recipients of list ORACLE-LSubject:   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
   
  <SPAN
  class=948534714-08012002>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
      <SPAN 
      class=160570313-08012002>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 
        > To: Multiple recipients of list ORACLE-L 
        > Subject: RE: Data Dictionary Wierdness 
        > > <FONT 
        size=2>> Yeah I saw that after I sent the email but it's still dumb 
        > IMHO. We can > 
        either blame achaudhr or his/her boss.  :-)  <FONT 
        size=2>> > More text from 
        catalog.sql: > Rem  achaudhr 10/25/95 - 
        PTI: Add lpads around degree, > instances, 
        cache