Re: compatible stetting on migrated 8i

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Fri, 21 Jan 2000 14:33:19 GMT
Message-ID: <38886E2F.8ED822C@edcmail.cr.usgs.gov>

The migration should not have changed the init.ora file. I would have done this manually.

Anyway, change your compatible setting to 8.1.5 and bounce your database. You should have no problems doing this.

HTH,
Brian

"Lothar Armbüster" wrote:
>
> Hello out there,
>
> I have an Oracle 8i (8.1.5) database which was migrated from 7.3.3.
> During the migration the compatible setting in init.ora was set to
> 8.0.5.0.0 but now I need some features (i.e. drop column) from 8i.
> Is it safe to set compatible to 8.1.0 or is there a good reason
> why the migraton set it to 8.0.5?
>
> Any ideas?
>
> Lothar
>
> --
> Lothar Armbrüster | lothar.armbruester_at_rheingau.netsurf.de
> Hauptstr. 26 | lothar.armbruester_at_t-online.de
> D-65346 Eltville |
Received on Fri Jan 21 2000 - 08:33:19 CST