Re: File too large !

From: Stephen Murphy <SMurphy1_at_NYCap.RR.Com>
Date: Tue, 11 Jan 2000 19:48:43 -0500
Message-ID: <387BCF6B.D6C8332F@NYCap.RR.Com>

The Unix account for Oracle probably has a limit set defining the largest file the account can create. You can either create the tablespace with multiple datafiles or get your Unix Sysadm to up/remove the limit.

Good luck.

"Michael Schäfer" wrote:
>
> Hi,
>
> is there a limitation on AIX that datafiles cannot be larger than 1024M ??
>
> create tablespace TEMP temporary
> datafile '/u01/oradata/@/temp_01.dbf' size 1024M reuse
> default storage (initial 256k next 2048k maxextents unlimited pctincrease
> 0 );
> ORA-01119: error in creating database file '/u01/oradata/@/temp_02.dbf'
> ORA-27044: unable to write the header block of file
> IBM AIX RISC System/6000 Error: 27: File too large
>
> This one works
> create tablespace TEMP temporary
> datafile '/u01/oradata/@/temp_01.dbf' size 1023M reuse
> default storage (initial 256k next 2048k maxextents unlimited pctincrease
> 0 );
>
> Thanks,
>
> Mike
Received on Tue Jan 11 2000 - 18:48:43 CST