Re: Error: ORA-01237 on Datafile Resize

Hi Virgil,

Do you have enough space on the volume? I am not sure, but I think that you cannot allocate the entire 2GB space because AIX needs some of it.

Regards

Jerry

Virgil Stay wrote:
>

 (SNIP)
>
> #ALTER DATABASE DATAFILE '/oracle/data4/dat2.dbf' RESIZE 2048000K
>
> #ORA-01237: cannot extend datafile 7
> #ORA-01110: data file 7: '/oracle/data4/dat2.dbf'
>
> Using 'oerr ora 1237' gives:
>
> 01237, 00000, "cannot extend datafile %s"
> // *Cause: An operating system error occurred during the resize.
> // *Action: Fix the cause of the operating system error and retry the
> command.
>
> The Oracle user has been verified with SMIT to have the rights to
> create a 2gig file. This has been tested at the command prompt. Disk
> integrity has also been checked. I cant seem to find a good reference
> on what other issues might be contributing to this error.
>
> Any insight would be much appreciated.
>
> Sincerely,
> Virgil
 

-- 
Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_p3.net 	Opinions are mine not those of ICT Group