Re: Compatible must be set to 7.2.0.0.0 problem...

Basic Question - what is point of compatible parameter? Generally it seems to be set to it's own version? Is this for mixed versions in distributed environment?
- Dc.

Sybrand Bakker wrote:

> Hi Jeff
>
> Are you running 7.2.3 or higher? If not, you can't resize datafiles.
> If yes, the value of your compatible parameter in init<sid>.ora is still
> 7.1.0.0 (the default) and you will need to increase it to 7.2.0.0, just as
> the message says and bounce the database.
> Then issue
> alter database datafile '<filename>' resize <n> M;
> If you don't know how to change the parameter, provide details about
> platform
> database version
> SID
> reply to this newsgroup, and we should be able to help you out.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
>
> Jeff Brouchard, Zenith Publishing Projects <jefferson.brouchard_at_tesco.net>
> wrote in message news:7r3j5p$c97$2_at_barcode.tesco.net...
> > I am trying to resize tablespace files and keep getting this message. I am
> > not a DBA and my company has no DBA. I know that this is a stupid
> question,
> > but how do I resize a database file?
> >
> > Thanks
> >
> >
> > J. Brouchard
> >
> >
Received on Tue Sep 07 1999 - 14:56:04 CDT