Yes, it's not error in SAS, but in Oracle. I tried to create table mytest in PL/SQL Developer, but source table bmv_tlb_tmp is big (it has 288'304'610 records). I've tried to reset parameter sort_area_size to 1048576000 or to 204857600, but it cause error: ORA-12801: error signaled in parallel query server P012 ORA-01652: unable to extend temp segment by 4096 in tablespace SAS Code: alter session set sort_area_size=204857600; create table mytest as select distinct EID, FIO_SEARCH, CAMP, RECALC_DATE, DATE_UPTO, O_CARD_SALARY, LAST_ANKETA_REF, LAST_ANKETA_BR, OFFER_ID, OFFER_STATUS_ID, OFFER_STATUS_CD, FD, max(FD) over (partition by FIO_SEARCH, OFFER_STATUS_CD) max_FD from bmv_tlb_tmp; How to fix the error?
... View more