Re: NAMESPACE column in OBJ$

From: Edgar Chupit <chupit_at_gmail.com>
Date: Sun, 25 May 2008 12:00:05 +0200
Message-ID: <a8f0771c0805250300w25cbc2x357444235138359@mail.gmail.com>

Hello Jeson,

This is decode of namespace from definition of gv$library_cache_memory:

decode(kglsim_namespace,

0,'SQL AREA',
1,'TABLE/PROCEDURE',
2,'BODY',
3,'TRIGGER',
4,'INDEX',
5,'CLUSTER',
6,'OBJECT',
7,'PIPE',
13,'JAVA SOURCE',

14,'JAVA RESOURCE',
32,'JAVA DATA', '?'), 1 - TABLE/PROCEDURE. I agree with you, that you can query user_tab_cols/user_tab_columns instead of querying internal objects.

On Sun, May 25, 2008 at 4:54 AM, Jason Heinrich <jheinrichdba_at_gmail.com> wrote:
> Could someone explain to me what the NAMESPACE column is for in the SYS.OBJ$
> table? I've been hunting around, but almost everything I've found so far
> has to do with OO programming, and the few web pages that have come up with
> that column don't actually say anything about it: it's just in some sample
> code.

-- 
Best regards,
 Edgar Chupit
 callto://edgar.chupit
--
http://www.freelists.org/webpage/oracle-l

Received on Sun May 25 2008 - 05:00:05 CDT