ORA-01653: unable to extend table, Zabbix

5077:20190126:173715.994 [Z3007] query failed: [-1] ORA-01653: unable to extend table ZABBIX.PROXY_HISTORY by 8192 in tablespace ZABBIX_TS
Seach for dbf files:
find / -name *.dbf
find / -name *.dbf | xargs ls -lh
This will report:
/u01/app/oracle/oradata/XE/sysaux.dbf
/u01/app/oracle/oradata/XE/system.dbf
/u01/app/oracle/oradata/XE/users.dbf
/u01/app/oracle/oradata/XE/undotbs1.dbf
/u01/app/oracle/oradata/XE/control.dbf
/u01/app/oracle/oradata/XE/temp.dbf
/u01/app/oracle/oradata/XE/zabbix_ts.dbf
ls -lh /u01/app/oracle/oradata/XE/zabbix_ts.dbf
This will report:
-rw-r-----. 1 oracle dba 4.4G Jan 26 17:51 /u01/app/oracle/oradata/XE/zabbix_ts.dbf
Authorize:
sqlplus sys as sysdba
Modify limits:
ALTER DATABASE DATAFILE '/u01/app/oracle/oradata/XE/zabbix_ts.dbf'
AUTOEXTEND ON NEXT 1M MAXSIZE 10240M;

No comments: