I just logged in as a database user and got the message
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
but logs me in.
I connected as system to run pupbld.sql and got a similar mesage.
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.
and got connected
I dont know if it is because of what and Iam not able to find the SP2 error message list from my documentation. The role resource does not seem to appear in the enterprise manager dba studio too.
Does anyone know what I can do about this. The users are not able to view the views like all_objects or user_objects.
None of the view all_ and user_ seem to be there.
Please suggest me a solution.
