File too large !

From: Michael Schäfer <MSchaefer2_at_de.lhsgroup.com>
Date: Tue, 11 Jan 2000 12:48:27 +0100
Message-ID: <387b188d@news.lhsgroup.com>

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 - 05:48:27 CST