ORA-1652: unable to extend temp segment by 256 in tablespace PSAPTEMP
在測試倒出時發生ORA－1652 ERROR，是在SAPAPPL1.LOG中
#START: 20070327015019
(EXP) ERROR: DbSlExeRead: rc = 99, table "QCMZPCED"
(SQL error 1652)
error message returned by DbSl:
ORA-01652: unable to extend temp segment by 256 in tablespace PSAPTEMP
#STOP: 20070327025836
研究一下，重啟RESET幫助不行，看來得加DATAFILE，一口氣將DATAFILE加倍了
ALTER TABLESPACE "PSAPTEMP" DEFAULT STORAGE ( MAXEXTENTS UNLIMITED )
ALTER TABLESPACE "PSAPTEMP" ADD DATAFILE 'g:oracleLMXsapdata1temp_5temp.data5' size 2088960 K
ALTER TABLESPACE "PSAPTEMP" ADD DATAFILE 'g:oracleLMXsapdata1temp_6temp.data6' size 2088960 K
ALTER TABLESPACE "PSAPTEMP" ADD DATAFILE 'g:oracleLMXsapdata1temp_7temp.data7' size 2088960 K
ALTER TABLESPACE "PSAPTEMP" ADD DATAFILE 'g:oracleLMXsapdata1temp_8temp.data8' size 2088960 K[@more@]
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/167898/viewspace-907056/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
- impdp ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'
- ORA-1653: unable to extend table by 1024 in tablespace(oracle表空間滿了的解決方案)Oracle
- ORA-27121: unable to determine size of shared memory segment
- oracle表空間不足：ORA-01653: unable to extend tableOracle
- 【Case】ORA-20000: Unable to set values for table DBMS_TABCOMP_TEMP_UNCMP
- 【故障處理】ORA-1688: unable to extend table AUDSYS.AUD$UNIFIEDNifi
- ORA-20000:unable to analyze table "XXX"."DBMS_TABCOMP_TEMP_UNCMP",insufficient privileges or does no
- temp
- SCSS @extendCSS
- $.extend()使用
- segment tree beats
- ORACLE ORA-1652的解決方法Oracle
- 如何找出引起ORA-1652的SQL？SQL
- Chunk extend OverlappingAPP
- Chunk Extend and OverlappingAPP
- MySQL 5.7 InnoDB Tablespace EncryptionMySql
- Oracle OCP(48)：UNDO TABLESPACEOracle
- dbv segment_id
- [Greenplum] 擴容segment
- Tablespace表空間刪除
- 理解jquery的$.extend()jQuery
- Segment Tree(線段樹)
- oracle temp 表空間Oracle
- temp資料夾可以刪除嗎 temp資料夾幹啥的
- jquery 擴充套件方法($.fn.extend/$.extend) 自定義外掛 拖拽jQuery套件
- offline tablespace 的幾種方式 (轉)
- Google I/O Extend 2018Go
- 關於_rollback_segment_count
- implementation 'com.guo.android_extend:android-extend:1.0.6'失敗解決方法Android
- 臨時表空間ORA-1652問題解決
- 【TABLESPACE】Oracle表空間最佳實踐Oracle
- mysql5.7 General tablespace使用說明MySql
- alter tablespace ts_name autoextend_clause
- Unable to find a specification for ''
- sass的mixin,extend,placeholder,functionFunction
- Sitecore ListManager Contact Lists vs Segment Lists
- 故障分析 | Greenplum Segment 故障處理
- Kafka中的segment的介紹Kafka