My Oracle Support Banner

Dba_tables Shows Next_extent Larger Than LMT Uniform Extent Size (Doc ID 840017.1)

Last updated on AUGUST 13, 2018

Applies to:

Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.


DBA_TABLES shows different for NEXT_EXTENT and the uniform extent size in Locally Managed Tablespace.

Under 9i or 10g, when NEXT is specified in the create table statement, the next_extent value in dba_tables shows as the uniform extent size of the tablespace. In 11g, the next_extent value in dba_tables shows as the size specified in NEXT in the create table statement.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.