Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: File too large !
Bingo,
Thanks, Pierre,
Pierre Charpenay <pcharpenay_at_unilog.fr> wrote in message
news:387B2153.906C5A49_at_unilog.fr...
>
>
> "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 - 08:13:37 CST