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-1652: unable to extend temp segment errors In RACError
- ORA-1652: unable to extend temp segment by 128 in tablespace錯誤的解決方法
- Oracle - ORA-01652: unable to extend temp segment by 128 in tablespace TEMPOracle
- Oracle - ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'Oracle
- tablespace 大檔案，undo，temp tablespace
- [Oracle Script] check temp tablespace usageOracle
- How to Diagnose and Resolve UNABLE TO EXTEND ErrorsError
- TEMP表空間報ORA-1652的處理
- [Oracle] 檢視tablespace的使用率(Including temp tablespace)Oracle
- ORA-1653: unable to extend table by 1024 in tablespace(oracle表空間滿了的解決方案)Oracle
- Failure to extend rollback segment 2 because of 1000 conditionAI
- recover database delete archivelogs skip tablespace temp;報錯DatabasedeleteHive
- Oracle佇列鎖enq:TS,Temporary Segment (also TableSpace)Oracle佇列ENQ
- oracle表空間不足：ORA-01653: unable to extend tableOracle
- 手工建庫後表空間資料檔案非自動擴充套件引起的錯誤：ORA-01653: unable to extend* in tablespace*套件
- 解決ORA-27125: unable to create shared memory segment
- 【故障處理】ORA-1688: unable to extend table AUDSYS.AUD$UNIFIEDNifi
- ORA-27125:unable to create shared memory segment 解決方法
- ORA-27125:unable to create shared memory segment 解決方法?
- Linux 10g --ORA-27125: unable to create shared memory segmentLinux
- DBCA建立ASM報錯ORA-27125: unable to create shared memory segmentASM
- $.extend()和$.fn.extend()區別
- temp
- create table進階學習(二)_dba_free_temp_space_v$tempseg_usage_v$sort_segment
- 研究 - IMPDP [TRANSFORM=segment_attributes:n] [remap_tablespace] 2引數間影響關係ORMREM
- ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'錯誤解決
- $.extend()和$.fn.extend()函式用法函式
- jquery.fn.extend與jquery.extendjQuery
- SCSS @extendCSS
- 理解jquery的$.extend()、$.fn和$.fn.extend()jQuery
- Linux 6.2 安裝Oracle 10g ORA-27125:unable to create shared memory segmentLinuxOracle 10g
- TEMP表空間不足解決 - temp group
- jQuery.extend()jQuery
- jQuery.extend和jQuery.fn.extend的區別jQuery
- jquery的$.extend和$.fn.extend作用及區別jQuery
- jQuery - 函式 $.extend 和 $.fn.extend 的說明jQuery函式
- 【Spring】java.lang.IndexOutOfBoundsException: Index: 256, Size: 256SpringJavaIndexException
- Delete the temp tabledelete