pupbld.sql

[sudheer_nm]

Hi Guys,
I have created a database with Oracle 9i and ran the following scripts.
catalog.sql,catproc.sql and pupbld.sql. pupbld.sql(executed using system account) shows the following error.
Let me know if i can do anything on that.
Regards,
Sudheer
======================================================
Connected.
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


CREATE TABLE SQLPLUS_PRODUCT_PROFILE
*
ERROR at line 1:
ORA-01658: unable to create INITIAL extent for segment in tablespace ACC


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


FROM SQLPLUS_PRODUCT_PROFILE
*
ERROR at line 4:
ORA-00942: table or view does not exist


GRANT SELECT ON PRODUCT_PRIVS TO PUBLIC
*
ERROR at line 1:
ORA-00942: table or view does not exist


DROP PUBLIC SYNONYM PRODUCT_PROFILE
*
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist



Synonym created.

DROP SYNONYM PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-01434: private synonym to be dropped does not exist



Synonym created.

DROP PUBLIC SYNONYM PRODUCT_USER_PROFILE
*
ERROR at line 1:
ORA-01432: public synonym to be dropped does not exist



Synonym created.

[tharakab]

That is not at all a problem. those r the messages which u get when u run the script pupbld.sql. when you are logging as a user and if u r getting an error pertaining to pupbld then it is of concern. Hence first login as a)system user to the database and check up if u r able to login without any errors and then b)login as normal user and check up same and post the answer

[sudheer_nm]

Hi I have logged in with both system(system/AsptAt50) and normal user but normal user(acc/acc) login shows the following error.

C:\>sqlplus system/AsptAt50

SQL*Plus: Release 9.2.0.1.0 - Production on Wed Dec 4 12:39:27 2002

Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.


Connected to:
Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production

SQL> disconnect
Disconnected from Oracle9i Release 9.2.0.1.0 - Production
JServer Release 9.2.0.1.0 - Production
SQL> connect acc/acc
Error accessing PRODUCT_USER_PROFILE
Warning: Product user profile information not loaded!
You may need to run PUPBLD.SQL as SYSTEM
Connected.