April would like to say

-- 撈出oracle 保留字 select * from v$reserved_words ORDER BY KEYWORD desc -- 拆帳 / 分紅 profit share -- 結算 settle (v.) settlement (n.)

問題： ORA-01652: unable to extend temp segment (也被解讀為： ORA-01652 is usually caused by running out of space ) 解法：加大 temp tablespace 例如 1. Increase size of the temp tablespace 2. Increase sort_area_size and/or pga_aggregate_target (此篇說的) other reference： http://blog.oracle.com.cn/? uid-55467-action-viewspace- itemid-26509 參考來源： "Increase size of the temp tablespace Increase sort_area_size and/or pga_aggregate_target" - ORA-01652: unable to extend temp segment by string in tablespace string tips ( 在「Google 網頁註解」中檢視 )