In 8.1.7 is pupbld.sql loacted at ORACLE_HOME/dbs/? I just created a DB manually and I'm trying to run that script as system but anytime I try it does not work.
SP2-0310: unable to open file "/u01/app/oracle/product/8.1.7/dbs/pupbld.sql"
When I try to connect as an ordinary user, I get the message so I need to run that script:
SQL> connect michael_pak
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
This file is available at two locations
I could not find it.
$ cd $ORACLE_HOME/dev
ksh: /oradata/ora/oracle/product/8.1.7/dev: not found.
$ cd $ORACLE_HOME/ora81
ksh: /u01/app/oracle/product/8.1.7/ora81: not found.
I am using UNIX
It should be in $ORACLE_HOME/sqlplus/admin on unix. If not, from an OS prompt:
find . -name pupbld.sql -print
to find out where it is
Click Here to Expand Forum to Full Width