I am receiving this error when i tried to connect to the new user.
the whole error is that
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
is it necessary to run the pupbld.sql or i can live without it and also can i run it later on at anytime after loading the data.
it is urgent
07-17-2001, 12:50 PM
You can run it at anytime...
07-17-2001, 12:51 PM
Connect as SYSTEM user and run the pupbld.sql script which is there in $ORACLE_HOME/sqlplus/admin directory.This script creates the PRODUCT_USER_PROFILE table which can be used to disable some commands for a particular user at SQL*Plus prompt.
In case of any help please be free to ask me at firstname.lastname@example.org