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
You can run it at anytime...
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
ROhit Nirkhe,Oracle DBA,OCP 8i