OraFAQ Forum: Security » errors in running pupbld.sql script (2 Merged)

Home » RDBMS Server » Security » errors in running pupbld.sql script (2 Merged) (oracle 10.2.0.3 win 7)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

errors in running pupbld.sql script (2 Merged) [message #527544]

Tue, 18 October 2011 13:57

shvn23
Messages: 5
Registered: October 2011
Location: Lucknow

Junior Member

i have created database manually and this is what happens when i run the script and try to login as a user :

I am executing the script with SYSTEM as dba

SQL> @?/sqlplus/admin/pupbld.sql;

Synonym dropped.

DATE_VALUE FROM PRODUCT_USER_PROFILE
*
ERROR at line 3:
ORA-00980: synonym translation is no longer valid

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-01430: column being added already exists in table

CREATE TABLE SQLPLUS_PRODUCT_PROFILE
*
ERROR at line 1:
ORA-00955: name is already used by an existing object

DROP TABLE PRODUCT_PROFILE
*
ERROR at line 1:
ORA-00942: table or view does not exist

View dropped.

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> connect hr/hr;
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.
SQL> show user;
USER is "HR"
SQL>

Report message to a moderator

Re: errors in running pupbld.sql script [message #527549 is a reply to message #527544]

Tue, 18 October 2011 14:08

Michel Cadot
Messages: 54223
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

I am executing the script with SYSTEM as dba

Do you mean SYSTEM or SYSTEM AS SYSDBA?

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

EDIT: fixed quote tags

[Updated on: Wed, 19 October 2011 04:49] by Moderator

Report message to a moderator