'ORA-30036: unable to extend segment by 8 in undo tablespace 'PSAPUNDO'
917898Feb 16 2012 — edited Feb 16 2012Hi,
I am doing a SAP client import via STMS and encountered ORA-30036 for PSAPUNDO. This is Oracle 10.2.0.4 and size of PSAPUNDO is 20GB. DB size is 180GB and using AUM. PSAPUNDO is set to Autoextend and there were enough disk space in the folder.
File name File Id Tablespace name Size(MB) #Blocks Status Relative file number Autoextend Maxsize(MB
Z:\ORACLE\B20\SAPDATA1\UNDO_1\UNDO.DATA1 2 PSAPUNDO 10,000.00 1,280,000 AVAILABLE 2 YES 10,000.00
Z:\ORACLE\B20\SAPDATA1\UNDO_2\UNDO.DATA2 33 PSAPUNDO 9,980.00 1,277,440 AVAILABLE 33 NO 0.00
Maxblocks Increment by User size(MB) User blocks
1280,000 2,560 9,999.93 1,279,992
0 0 9,979.93 1,277,432
1) Since PSAPUNDO is set to autoextend, why didn't it extend automatically when more space is required?
There are 2 datafiles for PSAPUNDO as above and is it because the second datafile UNDO.DATA2 was not set to autoextend?
2) Is it recommended to set Maxsize(MB) to unlimited so that it can extend freely during the Import? Of course I will need to ensure there are enough
disk space in Z.
Thank you all.