Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Help! Resizing datafiles

Re: Help! Resizing datafiles

From: Kevin Loney <kevin.loney_at_astramerck.com>
Date: 1997/08/13
Message-ID: <01bca7e9$96a8e180$aa9e02a7@LONEYK.astramerck.com>#1/1

Earvin C. Lim <earvin_at_omega.uta.edu> wrote in article <5sjqo6$7bq_at_news.uta.edu>...
> I tried to resize a datafile, but I got the following error:
>
> --
> alter database datafile '/usr/local/app/oracle/oradata/ACS/system01.dbf'
 resize 8M
> *
> ORA-00406: COMPATIBLE parameter needs to be 7.2.0.0.0 or greater
> --
>
> Does anyone know what's wrong? We are running Oracle 7.3.2.

You need to set COMPATIBLE to 7.2.0 or greater in your init.ora file and then
shutdown/restart the instance.

Kevin Loney. Received on Wed Aug 13 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US