SQL> alter tablespace DRSYS add datafile '/ora_data/drsys02.dbf' size 1000m;
alter tablespace DRSYS add datafile '/ora_data/drsys02.dbf' size 1000m
*
ERROR at line 1:
ORA-01119: error in creating database file '/ora_data/drsys02.dbf'
ORA-27040: skgfrcre: create error, unable to create file
Linux Error: 13: Permission denied
我查了一下,原来是/ora_data没有权限,后来
chown oracle.dba /ora_data就可以了
清除回收站
sql>purge recyclebin