Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help! Resizing datafiles
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
![]() |
![]() |