My Oracle Support Banner

Object's segment is Temporary (Doc ID 2531121.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.


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:


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.