My Oracle Support Banner

Very High Next_extent After Transportable Tablespace Exercise (Doc ID 1362579.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Server - Enterprise Edition - Version to [Release 10.2 to 11.2]
Information in this document applies to any platform.
This issue occurs if source database is 10g and destination database is But this issue is fixed in database version if both databases( Source and target are


A transportable tablespace exercise where 6 tablespaces were transported into a new database. After completion, all segments in those tablespaces had NEXT_EXTENT set to 17,592,186,036,224 (= 16 TB less 8192 bytes). Is this large NEXT_EXTENT setting expected behaviour after such an exercise?

On the source database: ( on AIX)

SQL> create tablespace transporttest datafile '/u02/app/BH01_TRANSPORTTEST_01.dbf' size 10M extent management local autoallocate segment space management auto;

SQL>create table ttest(x varchar2(100)) tablespace transporttest;

SQL>insert into ttest values ('A');


SQL>select initial_extent, next_extent from dba_segments where segment_name = 'TTEST';

--------------              -----------

SQL>alter tablespace transporttest read only;

On source database server:

exp transport_tablespace=Y tablespaces=TRANSPORTTEST file=ttest.dmp [connect / as sysdba]

On target database server:

Convert endian of datafile

imp file=ttest.dmp transport_tablespace=Y tablespaces=TRANSPORTTEST datafiles='/u02/app/BH01_TRANSPORTTEST_01.dbf'

On the  target database: ( on Linux)

SQL>col next_extent format 999,999,999,999,999
SQL>select initial_extent, next_extent from dba_segments where segment_name = 'TTEST';

--------------              --------------------
65536                      17,592,186,036,224

As you can see the next extent has been set extremely high.


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

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