My Oracle Support Banner

Object's segment is Temporary (Doc ID 2531121.1)

Last updated on JANUARY 29, 2020

Applies to:

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

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

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
Goal
Solution


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