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

From: Mohan, Ross <MohanR_at_STARS-SMI.com>
Date: Tue, 08 Jan 2002 06:29:50 -0800
Message-ID: <F001.003E9694.20020108054028@fatcity.com>

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.

-----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 Oracle Certified Professional

-----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----- >
 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 > 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 Received on Tue Jan 08 2002 - 08:29:50 CST