-
pupbld.sql
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.
-
pupbld.sql
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
-
Hi
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.