Hello Guys,
I am getting error as below
ORA-01653: unable to extend table TDOO32 by 8192 in tablespace MISTO_P01
when I check the tablespace size and free memory it is 99% free
SELECT a.tablespace_name tablespace,
ROUND(SUM(a.total1)/1024/1024, 1) "Total Mb",
ROUND(SUM(a.total1)/1024/1024, 1)-ROUND(SUM(a.sum1)/1024/1024, 1) "Used Mb",
ROUND(SUM(a.sum1)/1024/1024, 1) "Free Mb",
ROUND(SUM(a.sum1)/1024/1024,1)*100/ROUND(SUM(a.total1)/1024/1024,1) "Free %",
ROUND(SUM(a.maxb)/1024/1024, 1) "Largest Segment Size Mb"
FROM (SELECT tablespace_name,
0 total1,
SUM(bytes) sum1,
MAX(bytes) maxb,
COUNT(bytes) cnt
FROM dba_free_space
GROUP BY tablespace_name
UNION
SELECT tablespace_name,
SUM(bytes) total1,
0,
0,
0
FROM dba_data_files
GROUP BY tablespace_name) a
WHERE tablespace_name LIKE 'MISTO%'
GROUP BY a.tablespace_name;
| TABLESPACE | Total Mb | Used Mb | Free Mb | Free % Largest Segment Size Mb |
------------------------------ ---------- ---------- ---------- ---------- -----------------------
| MISTO_P01 | 5000 | 1 | 4999 | 99.98 | 3968 |
| MISTO_M01 | 2000 | 1 | 1999 | 99.95 | 1999 |
Free % is 99%.
what went wrong. Please help
S