PUPBLD.SQL not working [message #8302] |
Thu, 07 August 2003 13:34 |
LASCOLI
Messages: 18 Registered: November 2002
|
Junior Member |
|
|
When I log into 8i(Linux Redhat 8.0) , I receive the warning message below, and am instructed to run PUPBLD.SQL, which I do, but it does not resolve the issue. Any assistance would be most welcomed. Thank you
Enter user-name: dbimpl
Enter password:
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.1 - Production
With the Partitioning option
JServer Release 8.1.7.0.1 - Production
SQL> @/u01/app/oracle/product/8.1.7/sqlplus/admin/pupbld.sql
drop synonym product_user_profile
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
date_value from product_user_profile
*
ERROR at line 3:
ORA-00942: table or view does not exist
drop table product_user_profile
*
ERROR at line 1:
ORA-00942: table or view does not exist
alter table sqlplus_product_profile add (long_value long)
*
ERROR at line 1:
ORA-00942: table or view does not exist
Table created.
drop table product_profile
*
ERROR at line 1:
ORA-00942: table or view does not exist
drop view product_privs
*
ERROR at line 1:
ORA-00942: table or view does not exist
View created.
Grant succeeded.
Synonym dropped.
Synonym created.
drop synonym product_user_profile
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist
Synonym created.
Synonym dropped.
Synonym created.
SQL>
|
|
|
|
|
|
|
Re: PUPBLD.SQL not working [message #10440 is a reply to message #8328] |
Thu, 22 January 2004 05:27 |
Roberto Passuello
Messages: 1 Registered: January 2004
|
Junior Member |
|
|
Barbara Boehmer wrote:
"Did you try SYSTEM, instead of SYS? It might make a difference."
It does! I had the same problem that started the thread and found that it occurred bacause I ran the script as SYS and not SYSTEM! Next time I will read more carefully the warning! :-)
Roberto.
|
|
|