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

Last updated on FEBRUARY 02, 2017

Applies to:

Oracle Server - Enterprise Edition - Version 10.2.0.4 to 11.2.0.2 [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 11.2.0.2 But this issue is fixed in 11.2.0.2 database version if both databases( Source and target are 11.2.0.2)


Symptoms

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: (10.2.0.4 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>commit;

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

INITIAL_EXTENT NEXT_EXTENT
--------------              -----------
65536

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: (11.2.0.2 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';

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



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

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