Re: Error: ORA-01237 on Datafile Resize

1. If AIX is anything like industry standard unix then any file cannot be more than 2GB. 2048000K is 2048000 times 1024 which with a little file system overhead would be just over the 2GB limit.
2. Just add another datafile.
3. Although it may be possible to create datafiles up to 2GB or even greater on NT I personnaly do not recommend creating datafiles so big such that you can't relocate them easily when it becomes necessary. Personally I use a maximum file size of 1GB. You should simply add a datafile to this tablespace and create 2gb files.

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
Received on Tue Apr 21 1998 - 00:00:00 CDT