Re: 10g downwards compatibility

Christoph Kukulies <kuku_at_accms33.physik.rwth-aachen.de> wrote:
> After installing 10g I find that some things are different.
> Especially I had to rely on O7_dictioniary_accessibility=TRUE on init.ora.

> The parameter is understood. But still I have problems with the SYS user.
> Seems I cannot run an SQL script under user SYS any longer that creates some
> Views on SYS.all_tables or something in that vein.

I come back to the issue:

I installed 9.2.0.1.0 and found that editing the pfile (init.ora....) obviously doesn't do anything. Seems that the pfile is generated from the spfile on startup.

Now I tried to do an

ALTER SYSTEM SET o7_dictionary_visibility=true scope=both;

and get ORA-02095 (given initialization parameter cannot be modified - Angegebener Initialisierungsparameter kann nicht verändert werden.)

How can I alter that parameter?

--
Chris Christoph P. U. Kukulies kukulies (at) rwth-aachen.de