`

ORA-01691: unable to extend lob segment

阅读更多
ORA-01691: unable to extend lob segment
1.查询表空间使用情况:

SELECT Total.name "Tablespace Name",filepath,
Free_space, (total_space-Free_space) Used_space, total_space
FROM
(select tablespace_name, sum(bytes/1024/1024) Free_Space
from sys.dba_free_space
group by tablespace_name
) Free,
(select b.name, sum(bytes/1024/1024) TOTAL_SPACE,a.NAME as filepath
from sys.v_$datafile a, sys.v_$tablespace B
where a.ts# = b.ts#
group by b.name,a.NAME
) Total
WHERE Free.Tablespace_name = Total.name
2.
修改数据文件大小
alter database
datafile 'E:\ORACLE10\ORCLTABLESPACE\HORIZON_ ATTACHMENT.DBF' 
resize 300m  ;
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics