Done !!!!!!!!!!!!!! I have found that the the objects created by SYSTEM user is defaulting to a tablespace which is not there, i have altered the user SYSTEM and ran the PUPBLD.SQL again and it worked.
--Madhu > -----Original Message----- > From: Ray Stell [SMTP:[EMAIL PROTECTED]] > Sent: Sunday, April 14, 2002 8:18 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Product_User_profile > > On Sun, Apr 14, 2002 at 03:18:17PM -0800, Reddy, Madhusudana wrote: > > > > Enter user-name: ccadmin > > Enter password: > > Error accessing PRODUCT_USER_PROFILE > > Warning: Product user profile information not loaded! > > You may need to run PUPBLD.SQL as SYSTEM > -- > > > Note:1019310.102 ( edited to run in the alotted time ) > Type: PROBLEM > Status: PUBLISHED > Content Type: TEXT/PLAIN > Creation Date: 03-NOV-1999 > Last Revision Date: 22-JAN-2002 > > Problem Description: > ==================== > > You are receiving the following warning message when starting a SQL*Plus > session: > > "WARNING-PRODUCT USER PROFILE INFORMATION NOT LOADED" > > > > If you have run the "PUPBLD.SQL" script and are still receiving this > warning, > then do the following: > > Connect as user system, drop the PRODUCT_PRIVS view and rerun the > "PUPBLD.SQL" > script. > > > Explanation: > ============ > > SQL*Plus reads product restrictions from the PRODUCT_USER_PROFILE table > when a > user logs in to SQL*Plus, and maintains those restrictions for the > duration of > the session. Changes to PRODUCT_USER_PROFILE will only take effect the > next > time the affected users login to SQL*Plus. If the PRODUCT_USER_PROFILE > table is > created incorrectly, all users other than SYSTEM will see a warning when > connecting to Oracle from SQL*Plus, that the PRODUCT_USER_PROFILE > information > is not loaded. This message is a warning you that the > PRODUCT_USER_PROFILE > table has not been built in the SYSTEM account. > > Running the SQL script "PUPBLD.SQL" ( or "V7PUP.SQL" on some platforms) > will > build the PRODUCT_USER_PROFILE table, thus avioding the warning message. > . > -------------------------------------------------------------------------- > ------ > > Copyright (c) 1995,2000 Oracle Corporation. All Rights Reserved. Legal > Notices and Terms of Use. > =============================================================== > Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ray Stell > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).