RE: Product_User_profile

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:stellr_at_cns.vt.edu]
> 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 stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ray Stell
> INET: stellr_at_cns.vt.edu
>
> 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: ListGuru_at_fatcity.com (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: Madhusudana.Reddy_at_bestbuy.com

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: ListGuru_at_fatcity.com (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).