RE: o7_dictionary_accessibility

From: QuijadaReina, Julio C <QuijadJC_at_alfredstate.edu>
Date: Wed, 30 Apr 2003 12:46:56 -0800
Message-ID: <F001.0058D08D.20030430124656@fatcity.com>

   

Bulbultyagi,  

Try setting the parameter o7_dictionary_accessibility=true on your $ORACLE_HOME/dbs/init$ORACLE_SID.ora file or on your $ORACLE_HOME/dbs/spfile$ORACLE_SID.ora file  

Then shut your database down and start it back up.  

Take care,
Julio  

>Hi all,
>I am having a problem with a static parameter, I am using an spfile and
Oracle 9.0.1.1.1 on win32
>
>SQL> show user
>USER is "SYS"
>
>SQL> alter system set o7_dictionary_accessibility=true scope=spfile ;
>System altered.
>
>but even after shutting down and restarting the database
>
>SQL> show user
>USER is "SYS"
>SQL> show parameter o7
>
>NAME TYPE
>VALUE
>------------------------------------

---

>--------------------
>O7_DICTIONARY_ACCESSIBILITY boolean FALSE
>
>Any ideas?? I am able to change all other static parameters but not
this one
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
<http://www.orafaq.net/>
>--
>Author: <bulbultyagi_at_now-india.net.in
> INET: bulbultyagi_at_now-india.net.in
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: QuijadaReina, Julio C
  INET: QuijadJC_at_alfredstate.edu

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).

Received on Wed Apr 30 2003 - 15:46:56 CDT