NAME TOTAL USED FREE USED FILE_NAME
------------------------------ ---------- ---------- ---------- ---------- -----------------
RBS 1013760 518148 495612 51.1115057 /dev/vg11/rlvol1
RBS2 1013760 913412 100348 90.1014047 /dev/vg11/rlvol2
롤백세그먼트의 현재 사용량이 90%를 넘어서 추가 할려고 하는데.. 아래와 같은 에러가 발생합니다..
도와주세요..
SQL> ALTER TABLESPACE RBS2 ADD DATAFILE '/dev/vg11/rlvol2_1';
ALTER TABLESPACE RBS2 ADD DATAFILE '/dev/vg11/rlvol2_1'
*
ERROR at line 1:
ORA-01119: error in creating database file '/dev/vg11/rlvol2_1'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
|