Object's segment is Temporary (Doc ID 2531121.1)

Last updated on APRIL 17, 2023

Applies to:

Goal

If you create a big size table, you can see segment_type created for this table as temporary.

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

Test Case:

    create table tb2 tablespace users as select db1.* from dba_objects db1,dba_objects db2;
 

Check the segment tupe using below sql:

 select owner,segment_name,segment_type,tablespace_name,extent_id,bytes,blocks
 from dba_extents
 where tablespace_name='USERS'
 order by segment_name, extent_id;

-- When create sql is running, the result is follow:

Solution

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