[Oracle]解決ORA-01653: unable to extend table by in tablespace

解決方法：需要為tablespaces增加一個dbf file

查看現有dbf路徑

SELECT FILE_NAME, BYTES FROM DBA_DATA_FILES WHERE TABLESPACE_NAME = 'USERS';

為tablespaces新增一個data file

ALTER TABLESPACE USERS ADD DATAFILE '/u01/oradata/userdata02.dbf' SIZE 200M;

修改data file大小

alter database datafile '/u01/oradata/userdata02.dbf' RESIZE 1G; 

刪除data file

alter tablespace USERS drop datafile '/u01/oradata/userdata02.dbf';

刪除tablespaces

drop tablespace USERS1 including contents and datafiles cascade constraints;

data file自動擴展

alter database datafile '/u01/oradata/userdata02.dbf' autoextend on next 200M MAXSIZE 32G;