pupbld.sql
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: pupbld.sql

  1. #1
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104

    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.

  2. #2
    Join Date
    Oct 2002
    Location
    Bangalore,India
    Posts
    32

    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

  3. #3
    Join Date
    Dec 2002
    Location
    Chennai, India
    Posts
    104

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width