Objects Unable to Extend in Datafiles in AUTOEXTEND ON and MAXSIZE UNLIMITED - ORA-03206

(Doc ID 135291.1)

Last updated on JUNE 14, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 7.3.4.5 and later
Microsoft Windows (32-bit)
Checked for relevance on 21 June 2012
***Checked for relevance on 13-Jun-2016***

Symptoms

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. 

Cause

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