Re: O7_DICTIONARY_ACCESSIBILITY on 10g
From: <epokopac_at_excite.com>
Date: Thu, 24 Apr 2008 07:13:43 -0700 (PDT)
Message-ID: <4184a3f3-801a-4fd7-9d56-3d5c24496917@a23g2000hsc.googlegroups.com>
Date: Thu, 24 Apr 2008 07:13:43 -0700 (PDT)
Message-ID: <4184a3f3-801a-4fd7-9d56-3d5c24496917@a23g2000hsc.googlegroups.com>
VALUE - Parameter value for the session (if modified within the
session); otherwise, the instance-wide parameter value
ISDEFAULT - Indicates whether the parameter is set to the default value (TRUE) or the parameter value was specified in the parameter file (FALSE)
Looks like database1 has that parameter in it's "init" file.
Looks like database2 does not have that parameter in it's "init" file.
The default for O7_DICTIONARY_ACCESSIBILITY is FALSE. Looks like a "TRUE" in ISDEFAULT is an indication that you have decided to implement the parameter in your "init" file.
Regards,
Eugene Pokopac (Oracle DBA - GSFA - Tucker GA) Received on Thu Apr 24 2008 - 09:13:43 CDT