From NDATFM@labor.state.ny.us Tue, 08 Jan 2002 07:50:24 -0800
From: "Mercadante, Thomas F" <NDATFM@labor.state.ny.us>
Date: Tue, 08 Jan 2002 07:50:24 -0800
Subject: RE: Data Dictionary Wierdness a.k.a. Memory Serveth Not
Message-ID: <F001.003E9859.20020108065550@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: RE: Data Dictionary Wierdness



<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@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@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@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@rightnow.com">mailto:sorr@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