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: Dick Allie <dallie_at_ionet.net>
Date: 1997/08/14
Message-ID: <33F31570.2C89@ionet.net>#1/1

Earvin C. Lim wrote:
>
> Hi there,
>
> 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.
> Thanks in advance!
>
> Earvin Lim
> -- Programmer/Analyst
> -- Academic Computing Services
> -- University of Texas at Arlington
> email: elim_at_uta.edu
> Phone: (817)272-3678

Look at init.ora parameter compatible = 7.3.2 If it is not set or points to a previous version then change it and start up your database again.
Regards, Dick Received on Thu Aug 14 1997 - 00:00:00 CDT

Original text of this message

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