Object's segment is Temporary
(Doc ID 2531121.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 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.
create table tb2 tablespace users as select db1.* from dba_objects db1,dba_objects db2;
Check the segment tupe using below sql:
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