Re: NAMESPACE column in OBJ$
- From: "Edgar Chupit" <chupit@xxxxxxxxx>
- To: jheinrichdba@xxxxxxxxx
- Date: Sun, 25 May 2008 12:00:05 +0200
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@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
