Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: File too large !
"Michael Schäfer" a écrit :
> 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
There's a limit fixed by user. To change it, you must use 'smit user', and set
the parameter
'SOFT file size' to the desired value.
Received on Tue Jan 11 2000 - 06:25:55 CST