Re: Error: ORA-01237 on Datafile Resize

This may seem on obvious question, but I am not trying to be a smart arse, you do have 2GB of disk space free don't you? I mean before you start. If your existing file is 1.5GB and you have 1GB free, does Oracle manage to extend the existing file by the 0.5GB extra (in which case there is enough space) or does it create a completely new file of 2GB, copy the requisite info, and delete the original file (in which case there isn't enough space).

Dave O'Keeffe

Virgil Stay wrote:
>
> I have an Oracle 7.3.3 db on AIX 4.2. I'm using the Oracle Enterprise
> Manager from an NT40 desktop. From Storage manager I was trying to
> increase the datafile from 1gig to 2gig with the following command and
> resulting error:
>
> #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
 

-- 
For email replys remove "n0spam." from the above address