ERROR at line 62: ORA-01652: unable to extend temp segment by 16 in tablespace [message #615040] |
Thu, 29 May 2014 12:04  |
Mohan10g
Messages: 159 Registered: May 2009 Location: INDIA
|
Senior Member |

|
|
Hi ,
When i try to create Materilized view in test database, i get following error.
Quote:ERROR at line 62:
ORA-01652: unable to extend temp segment by 16 in tablespace DATA_01
Current tablespace sizes are below.
Quote:TBS_NAME MEGS_ALLOC MEGS_FREE MEGS_USED PCT_FREE PCT_USED MAX_MEGS_ALLOC MAX_PCT_FREE MAX_PCT_USED
------------------------------ ---------- ---------- ---------- ---------- ---------- -------------- ------------ ------------
DATA_01 16384 2343 14041 14.3 85.7 16384.1 14.3 85.7
MAINTENANCE 256 64 192 24.95 75.05 256.06 24.95 75.05
SYSTEM 2000 707 1294 35.33 64.67 2000 35.32 64.68
DEMO_04 14336 5961 8375 41.58 58.42 14336.09 41.58 58.42
UNDOTBS1 1536 1449 87 94.33 5.67 1536.06 94.33 5.67
Can you tell me how much space should be added to free up space to the tablespace DATA_01 based on the current sizes ?
Regds,
Mohan
|
|
|
|
|
|
|
|
|