Re: Oracle 7.3.3.4.0 on OpenVMS

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Thu, 24 Jun 1999 08:58:07 -0700
Message-ID: <3772558F.AA60898E@us.oracle.com>

Heidi

You've lost me here. The init.ora parameter should read compatible=7.3.3. Is it currently set to that or 7.3.0? Do a select value from v$parameter where name = 'compatible' and see what it's set to. You certainly don't need to recreate controlfiles or anything like that.

Again, it would help if you told us what the error was, rather than "it won't let me create a bitmap index".

HTH. Pete

Heidi Schuerger wrote:

> INIT.ORA should have: COMPATIBLE=7.3.0
> so, I changed it and cycled the database, but it still won't let me create a
> BITMAP INDEX.
>
> I didn't think I had to to
> ALTER DATABASE RESET COMPATIBILITY
> and
> CREATE CONTROLFILE (...)
> unless I was downgrading.

Regards

Pete

Received on Thu Jun 24 1999 - 10:58:07 CDT