环境:oracle 10g,数据库使用ASM存储,通过以下命令创建一个临时表空间:
SQL> create temporary tablespace temp1
2 tempfile size 10m tablespace group orclgrp;
create tmeporary tablespace temp1create temporary tablespace temp1
*
ERROR at line 1:
ORA-01119: error in creating database file '+DATA'
ORA-17502: ksfdcre:4 Failed to create file +DATA
ORA-15041: diskgroup space exhausted
运行命令select path,total_mb,free_mb from v$asm_disk_stat;
SQL> select path,total_mb,free_mb from v$asm_disk_stat;
PATH TOTAL_MB FREE_MB
--------------- ---------- ----------
ORCL:V1 4094 2985
ORCL:V2 &nb