ORA-1652 detected while creating CMP3$ tables

Hi Team,

In past two days i can see errors in alert log like ORA-1652: unable to extend temp segment by 16 in tablespace APPS_TS_TX_DATA at same time 12:30 AM.

I have generated stats pack report for this period of time and I can see that several tables (11 total) were created like:

create table "ZX".CMP3$411321 tablespace "APPS_TS_TX_DATA" nologging as select /*+ DYNAMIC_SAMPLING(0) FULL("ZX"."ZX_LINES_DET_FACTORS") */ * from "ZX"."ZX_LINES_DET_FACTORS" sample block( .2) mytab

create table "AP".CMP3$393821 tablespace "APPS_TS_TX_DATA" nologging as select /*+ DYNAMIC_SAMPLING(0) FULL("AP"."AP_INVOICE_DISTRIBUTIONS_ALL") */ * from "AP"."AP_INVOICE_DISTRIBUTIONS_ALL" sample block( .2) mytab