OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » what is missing?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

what is missing? [message #58969]

Sun, 19 October 2003 00:03

Kapil
Messages: 145
Registered: May 2002

Senior Member

I was trying to describe DBMS_RLS Package, i got this error message. i connected as sys, even though i got this error message. what is the reason?

SQL> desc DBMS_RLS
ERROR:
ORA-24372: invalid object for describe

Report message to a moderator

Re: what is missing? [message #58974 is a reply to message #58969]

Mon, 20 October 2003 02:05

Maaher
Messages: 7065
Registered: December 2001

Senior Member

Well you seem to have some problems. the object you try to describe is invalid. Normally a recompilation of the object would do the trick. Look for more invalid objects and try to recompile them. The status of objects can be found in user_objects, all_objects and dba_objects if I'm not mistaken. Search for objects with status 'INVALID'.

MHE

Report message to a moderator

Re: what is missing? [message #58978 is a reply to message #58974]

Mon, 20 October 2003 06:07

Kapil
Messages: 145
Registered: May 2002

Senior Member

Thanks a lot for your help, what i did is, i ran dbmsrlsa.sql script from $ORACLE_HOME/rdbms/admin. and it fixed my problem. Thanks again.

Report message to a moderator

Previous Topic:	ORA 1036 illegal variable name/number
Next Topic:	DB Links

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 15:32:27 CDT 2024