My Oracle Support Banner

Objects Unable to Extend in Datafiles in AUTOEXTEND ON and MAXSIZE UNLIMITED - ORA-03206 (Doc ID 135291.1)

Last updated on FEBRUARY 02, 2022

Applies to:

Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Microsoft Windows (32-bit)

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. 

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.