SQL> create table COMP_TEMP as select * from COMPETITIVE;
create table COMP_TEMP as select * from COMPETITIVE
                                          *
ERROR at line 1:
ORA-01652: unable to extend temp segment by 128 in tablespace DATA_01

07:42:18 SQL> select segment_type, count(*) from dba_segments group by segment_type order by 1;

SEGMENT_TYPE	     COUNT(*)
------------------ ----------
CLUSTER 		   10
INDEX			 2439
INDEX PARTITION 	 1606
LOB PARTITION		    1
LOBINDEX		  748
LOBSEGMENT		  748
NESTED TABLE		   39
ROLLBACK		    1
TABLE			 1817
TABLE PARTITION 	 1413
TABLE SUBPARTITION	    3

SEGMENT_TYPE	     COUNT(*)
------------------ ----------
TYPE2 UNDO		   24

12 rows selected.

07:43:02 SQL>