Fwd: NAMESPACE column in OBJ$

For some reason the post was deemed to be too long.

Here's a trimmed version:

For something like this, you can also always check sql.bsq in $ORACLE_HOME/rdbms/admin:

create table obj$                                            /* object table


*/

( obj#          number not null,                            /* object number

• TRANSACTION DURING TRUNCATE */ dataobj# number, /* data layer object number
  */
  owner# number not null, /* owner user number
  */
  name varchar2("M_IDEN") not null, /* object name
  */
  namespace number not null, /* namespace of object (see KQD.H):
  */
  /* 1 = TABLE/PROCEDURE/TYPE, 2 = BODY, 3 = TRIGGER, 4 = INDEX, 5 = CLUSTER,
  */
  /* 8 = LOB, 9 = DIRECTORY,
  */
  /* 10 = QUEUE, 11 = REPLICATION OBJECT GROUP, 12 = REPLICATION PROPAGATOR,
  */
  /* 13 = JAVA SOURCE, 14 = JAVA RESOURCE
  */
  /* 58 = (Data Mining) MODEL
  */
  subname varchar2("M_IDEN"), /* subordinate to the name
  */
  ... ... spare2 number, /* object version number
  */
  spare3 number, spare4 varchar2(1000), spare5 varchar2(1000), spare6 date ) storage (initial 10k next 100k maxextents unlimited pctincrease 0) /

BTW In 11g the file has been split up, it's in dcore.bsq

Stefan

-- 
=========================

Stefan P Knecht
Senior Consultant
Infrastructure Managed Services

Trivadis AG
Europa-Strasse 5
CH-8152 Glattbrugg

Phone +41-44-808 70 20
Fax +41-808 70 12
Mobile +41-79-571 36 27
stefan.knecht_at_trivadis.com
http://www.trivadis.com

OCP 9i/10g SCSA SCNA
=========================

--
http://www.freelists.org/webpage/oracle-l