-
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
Santosh
-
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 is
Jeff Hunter
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|