Re: Help! Resizing datafiles

Inside your init<sid>.ora file you probably have a parameter called COMPATIBLE. This allows to change the way the database functions. ie Your 7.3.2 database can function like a 7.1 database by setting this parameter to 7.1.

 The datafile resize command was added in 7.2, so the parameter needs to be set at 7.2 or higher for this command to work.

Roy Klassen rklassen_at_pei.sympatico.ca

Earvin C. Lim <earvin_at_omega.uta.edu> wrote in article <5sjqo6$7bq_at_news.uta.edu>...
> 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
>
Received on Sun Aug 10 1997 - 00:00:00 CDT