Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

please help me fix the bug relate to x$kzsro

802715Oct 3 2010 — edited Oct 4 2010
Dear everybody

I'm new to oracle. I'm using Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 in window vista.

recently, i try to run this code :

select u.name, o.obj#, o.name,
decode(o.type#, 2, 'TABLE', 4, 'VIEW')
from sys.user$ u, sys.obj$ o
where o.owner# = u.user#
and o.linkname is null
and o.type# in (2, 4)
and (o.owner# = uid
or
obj# in (select obj#
from sys.objauth$
where grantee# in (select kzsrorol from x$kzsro)
or grantee#=uid
)
);

and encounter error :


Error starting at line 1 in command:
select u.name, o.obj#, o.name,
decode(o.type#, 2, 'TABLE', 4, 'VIEW')
from sys.user$ u, sys.obj$ o
where o.owner# = u.user#
and o.linkname is null
and o.type# in (2, 4)
and (o.owner# = uid
or
obj# in (select obj#
from sys.objauth$
where grantee# in (select kzsrorol from x$kzsro)
or grantee#=uid
)
)
Error at Command Line:11 Column:56
Error report:
SQL Error: ORA-00942: table or view does not exist
00942. 00000 - "table or view does not exist"
*Cause:
*Action:

this error relate to table or view x$kzsro in oracle 10.2

i can't fix this bug.so please help me.
thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 1 2010
Added on Oct 3 2010
8 comments
1,227 views