Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: what is user_objects.DATA_OBJECT_ID?

Re: what is user_objects.DATA_OBJECT_ID?

From: G M <zlmei_at_hotmail.com>
Date: 8 Mar 2002 19:33:34 -0800
Message-ID: <50a5e6b6.0203081933.7682bc15@posting.google.com> 





Thanks for your reply.




This index is not partitioned on either of them:



on db1:



SQL> select INDEX_NAME, INDEX_TYPE,PARTITIONED from user_indexes
  2  where INDEX_NAME = 'COREREF_ABSTRACT';


INDEX_NAME                     INDEX_TYPE                  PAR
------------------------------ --------------------------- ---
COREREF_ABSTRACT               DOMAIN                      NO






SQL> select PARAMETERS from user_indexes where INDEX_NAME =
'COREREF_ABSTRACT';


PARAMETERS





memory 50M




on db2:



SQL> select INDEX_NAME, INDEX_TYPE,PARTITIONED from user_indexes
  2  where INDEX_NAME = 'COREREF_ABSTRACT';


INDEX_NAME                     INDEX_TYPE                  PAR
------------------------------ --------------------------- ---
COREREF_ABSTRACT               DOMAIN                      NO





SQL> select PARAMETERS from user_indexes where INDEX_NAME =
'COREREF_ABSTRACT';


PARAMETERS





sync memory 50M




Actually this index was created on "db1" manually (see the script
below) and I want to find out where this index's data is:


---

BEGIN   
ctxsys.driimp.create_index('COREREF_TITLE','CORE_REF',USER, 
'REFID','2','TITLE','1', 
'1600','789189','8130','789190', 
NULL, NULL, NULL ); 
  
  
ctxsys.driimp.set_object('DATASTORE','DIRECT_DATASTORE',0); 
  
ctxsys.driimp.set_object('DATATYPE','CHAR_DATATYPE',0); 
  
ctxsys.driimp.set_object('DATAX','SYNCH_DATAX',0); 
  
ctxsys.driimp.set_object('FILTER','NULL_FILTER',0); 
  
ctxsys.driimp.set_object('SECTION_GROUP','NULL_SECTION_GROUP',0); 
  
ctxsys.driimp.set_object('LEXER','BASIC_LEXER',3); 
ctxsys.driimp.set_value('INDEX_TEXT','1'); 
ctxsys.driimp.set_value('INDEX_THEMES','0'); 
ctxsys.driimp.set_value('WHITESPACE','-_/(){}[]#@,<>:"|+=&'); 
  
ctxsys.driimp.set_object('WORDLIST','BASIC_WORDLIST',1); 
ctxsys.driimp.set_value('STEMMER','1'); 
  
ctxsys.driimp.set_object('STOPLIST','BASIC_STOPLIST',365); 

CREATE INDEX "ISI"."COREREF_ABSTRACT" ON "CORE_REF" ("ABSTRACT" ) 
INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('sync memory 50M') ;
ctxsys.driimp.set_value('STOP_WORD','a'); 
ctxsys.driimp.set_value('STOP_WORD','about'); 
ctxsys.driimp.set_value('STOP_WORD','above'); 
ctxsys.driimp.set_value('STOP_WORD','abs'); 
--
-- many similar statments here with different word
--
ctxsys.driimp.set_value('STOP_WORD','you'); 
ctxsys.driimp.set_value('STOP_WORD','your'); 
ctxsys.driimp.set_value('STOP_WORD','yours'); 
ctxsys.driimp.set_value('STOP_WORD','yourself'); 
ctxsys.driimp.set_value('STOP_WORD','yourselves'); 
  
ctxsys.driimp.set_value('STOP_WORD','yr'); 
  
ctxsys.driimp.set_object('STORAGE','BASIC_STORAGE',6); 
ctxsys.driimp.set_value('I_TABLE_CLAUSE','tablespace RESINDEX storage 


(initial 1000M next 500M pctincrease 0)'); 

ctxsys.driimp.set_value('K_TABLE_CLAUSE','tablespace RESINDEX storage 


(initial 1000M next 500M pctincrease 0)'); 

ctxsys.driimp.set_value('R_TABLE_CLAUSE','tablespace RESINDEX storage 


(initial 1000M next 500M pctincrease 0)'); 

ctxsys.driimp.set_value('N_TABLE_CLAUSE','tablespace RESINDEX storage 


(initial 1000M next 500M pctincrease 0)'); 

ctxsys.driimp.set_value('I_INDEX_CLAUSE','tablespace RESINDEX storage 


(initial 1000M next 500M pctincrease 0)'); 

ctxsys.driimp.set_value('P_TABLE_CLAUSE','tablespace RESINDEX storage 


(initial 1000M next 500M pctincrease 0)'); 

  
commit; 
COMMIT; END; 

CREATE INDEX "ISI"."COREREF_ABSTRACT" ON "CORE_REF" ("ABSTRACT" ) 
INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('memory 50M') ;

------

I had to pass the parameter ('memory 50M') in order to execute the
statement, it was originally ('sync memory 50M') from the db2 dump
file.

basically I just want to make sure the index was created correctly


(with data) in "db1". How could I check that?


Guang
---------
"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<1015537245.7010.0.nnrp-12.9e984b29_at_news.demon.co.uk>...
> The data_object_id is an identifier for the physical
> data segment currently holding data for the object_id.
> This allows Oracle to track objects logically, even
> if you do things like 'rebuild index', 'truncate table'.
> 
> In answer to the NULL data_object_id - this may
> be because COREREF_ABSTRACT is partitioned
> in one database, so the object never has its own
> data segment, but its partitions do; whilst it is
> not partitioned in the other database - on the
> other hand we can see from the other database
> that the object_id does not match the data_object_id,
> so it must have been truncated or rebuilt at least once.
> (Note also the discrepancy between CREATED
> date and LAST_DDL date)
> 
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
> 
> Next Seminar - UK, April 3rd - 5th
> http://www.jlcomp.demon.co.uk/seminar.html
> 
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
> 
> Author of:
> Practical Oracle 8i: Building Efficient Databases
> 
> 
> G M wrote in message <50a5e6b6.0203071314.7ba72709_at_posting.google.com>...
> >Hi:
> >
> >I have a question about user_objects.DATA_OBJECT_ID column.
> >
> >According to Oracle's Documentation:
> >
> >-------
> >DATA_OBJECT_ID   NUMBER
> >
> >Dictionary object number of the segment that contains the object
> >
> >Note: OBJECT_ID and DATA_OBJECT_ID display data dictionary metadata.
> >Do not confuse these numbers with the unique 16-byte object identifier
> >("object ID") that Oracle assigns to row objects in object tables in
> >the system.
> >--------
> >
> >We have two databases and in them there is one index that I am trying
> >to compare. The only difference is that one of them has
> >"DATA_OBJECT_ID" null. What does that mean?
> >
> >on db1:
> >
> >SQL> select * from user_objects where object_name =
> >'COREREF_ABSTRACT';
> >
> >OBJECT_NAME
> >---------------------------------------------------------------------------
>  -----
> >SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
> >------------------------------ ---------- --------------
> >------------------
> >CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S
> >--------- --------- ------------------- ------- - - -
> >COREREF_ABSTRACT
> >                                     6281                INDEX
> >08-FEB-02 08-FEB-02 2002-02-08:05:11:46 VALID   N N N
> >
> >
> >
> >on db2:
> >
> >SQL> select * from user_objects where object_name =
> >'COREREF_ABSTRACT';
> >
> >OBJECT_NAME
> >---------------------------------------------------------------------------
>  -----
> >SUBOBJECT_NAME                  OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE
> >------------------------------ ---------- --------------
> >------------------
> >CREATED   LAST_DDL_ TIMESTAMP           STATUS  T G S
> >--------- --------- ------------------- ------- - - -
> >COREREF_ABSTRACT
> >                                     4928           9401 INDEX
> >11-SEP-00 03-MAR-02 2000-09-11:16:55:12 VALID   N N N


Received on Fri Mar 08 2002 - 21:33:34 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US