-
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.
e.g.
SQL> @$ORACLE_HOME/dbs/pupbld.sql
SP2-0310: unable to open file "/u01/app/oracle/product/8.1.7/dbs/pupbld.sql"
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
Enter password:
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
-
Hi,
This file is available at two locations
1) ORACLE_HOME/ora81/sqlplus/admin
2) ORACLE_HOME/dev/DBS
Regards
-
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:
cd $ORACLE_HOME
find . -name pupbld.sql -print
to find out where it ishttp://www.dbasupport.com/forums/
-