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

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 - 13:30:24 CDT