Re: what is user_objects.DATA_OBJECT_ID?

"db1" is oracle 817 I just created. "db2" is oracle 816 db that we have beening using for a couple of years. I used export/import to duplicate db2. Anyway as a test, I created a new 816 instance (let's day db3) and used exp/imp to duplicate db2. I got the same thing (no user_objects.DATA_OBJECT_ID value in db3) so this means it is unlikely Context stuff has changed between 816 and 817 as least in this part.

I guess the only way to know this is to see if I hear complaints from users about the performance, although I am still puzzled why I got null value on DATA_OBJECT_ID column even though I thought the index got created with "ctxsys.driimp.set_value" executed;

Guang

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:<1015660441.12897.0.nnrp-08.9e984b29_at_news.demon.co.uk>...
> Well,
>
> The concept is the same, but the specific
> details are different for context server.
>
> I don't know the internal arrangements,
> but it is still a case of an object without
> a data segment - in this case you have
> a DOMAIN index, which allows for a
> user (or Context programmer) defined
> structure. This could, for example, mean
> that the context software knows that the
> index definition is actually redirecting it
> to a 'hidden' table with a couple of other
> indexes.
>
> One guess why the two databases give
> different reports is that the two indexes
> seem to have been created some years
> apart, so perhaps some internal convention
> in Context has changed in the interim.
>
> Sorry I can't help further.
>
> --
Received on Sat Mar 09 2002 - 08:12:43 CST