Dba_tables Shows Next_extent Larger Than LMT Uniform Extent Size
Last updated on MARCH 01, 2017
Applies to:Oracle Server - Enterprise Edition - Version: 220.127.116.11
This problem can occur on any platform.
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms