ORA-01652: unable to extend temp segment by 512 in tablespace GEN_DATA

ISSUE

-----------

Trying to create a table by issuing the following statement:

Create table wh_receivable_sum_t1 as select * from wh_receivable_sum;

This is a large table with a lot of rows.

ORA-01652: unable to extend temp segment by 512 in tablespace GEN_DATA

SOLUTION

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

ORA-01652:	unable to extend temp segment by string in tablespace string
Cause:	Failed to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.
Action:	Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.

( http://ora-01652.ora-code.com/ )

RESULTS

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

gen@PRD3S> select count(*) from wh_receivable_sum;

COUNT(*)
----------
9885692

gen@PRD3S> create table ds_t1 as select * from wh_receivable_sum;

Table created.

gen@PRD3S> select count(*) from ds_t1;

COUNT(*)
----------
9885692

gen@PRD3S> drop table ds_t1;

Table dropped.