Objects Unable to Extend in Datafiles in AUTOEXTEND ON and MAXSIZE UNLIMITED - ORA-03206
Last updated on JUNE 14, 2016
Applies to:Oracle Database - Enterprise Edition - Version 220.127.116.11 and later
Microsoft Windows (32-bit)
Checked for relevance on 21 June 2012
***Checked for relevance on 13-Jun-2016***
You insert new rows into a table with SQL*Loader and get the following errors, though the datafile of the tablespace is autoextendable to a unlimited maxsize:
ORA-1653 unable to extend table T_APPLI by 25600 in tablespace USERS
SQL*Loader-00605 Non-data dependent ORACLE error occurred -- load discontinued.
Cause: An error occurred that is independent of the data. For example, an out-of-space condition. Because all further rows will be rejected, the load is discontinued.
(If the error were data dependent, then other rows might succeed.)
The DB_BLOCK_SIZE is 4K.
The NEXT increment for the autoextensibility is 1Gb (256000 blocks of 4K each).
The NEXT extent of the table is 100Mb (25600 blocks of 4k each).
This error means that you have no space left on the datafiles of the tablespace for the NEXT extent of the table to be created.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms