8.1.7.4.0 installs - please check to see if an object exists

[khussain]

Can someone that has a 8.1.7.4.0 install (we are on Compaq TRU64 Unix 5.0F); check to see if this object exists:

sys.sys_user$

select * from dba_objects
where object_name = 'SYS_USER$';

I am migrating from 8.1.7.3 to 8.1.7.4, and some objects are invalid, because they are looking for this sys view.

Thanks.

[vinit]

Isn't that just sys.user$ ?

[khussain]

This is what I got from 8.1.7.3.0

OWNER
------------------------------
OBJECT_NAME
----------------------------------------------------------------------------------------------------
SUBOBJECT_NAME OBJECT_ID DATA_OBJECT_ID OBJECT_TYPE CREATED LAST_DDL_
------------------------------ ---------- -------------- ------------------ --------- ---------
TIMESTAMP STATUS T G S
------------------- ------- - - -
SYS
SYS_USER$
3799 VIEW 20-MAY-02 20-MAY-02
2002-05-20:09:25:33 VALID N N N

[vinit]

You can see the object_type is 'VIEW'. I personally have not come across any such object. Perhaps you installed some tools on user sys which created this view. Can you check out the text and see the dependencies for this view ?