Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-1654 , Oracle asking for very large extent
[...]
> Something seems amiss...There is 7GB of free space in the tablespace. The
> max extent allocated with AUTOALLOCATE is 8MB.
[...]
See http://www.jlcomp.demon.co.uk/ch_08.html Autoallocated Tablespaces
Regards
Dimitre
P.S. I found an explanation for the oracle autoallocate algorithm in the Sybex Oracle 10g Administration I Study Guide too, but I don't know where the information is comming from and if it's reliable. Received on Mon Jul 31 2006 - 11:15:34 CDT