Re: invalid xdb operators

From: Ben <balvey_at_comcast.net>
Date: Wed, 19 Sep 2007 06:43:32 -0700
Message-ID: <1190209412.189346.230730@57g2000hsv.googlegroups.com>

On Sep 19, 9:35 am, Ben <bal..._at_comcast.net> wrote:
> 10.2.0.2 Ent Ed, Aix5L
>
> I just installed xml database and was checking for invalid objects and
> found two operators that are listed as invalid.
>
> select owner, object_name, object_type from dba_objects
> where owner='XDB' and status='INVALID';
>
> XDB PATH OPERATOR
> XDB DEPTH OPERATOR
>
> Are operators compiled or do you have to drop and re-create them? All
> I can find in the data cartridge manual are statements on creating,
> altering, envoking, and dropping operators. Haven't seen anything on
> how to handle invalid operators.

Sorry, jumped the gun.
I didn't thouroughly search on here.

I found a post by Sybrand that pointed me to

alter <objecttype> <objectname> compile; Received on Wed Sep 19 2007 - 08:43:32 CDT