TNPM/db extend
From neil.tappsville.com
Jump to navigationJump to search
Only the metric data tablespaces auto-extend by default
As a system grows both the meta-data and temporary tablespaces may need to be extended
grep ORA-1655 alert_PV.log ORA-1655: unable to extend table SYS.C_TS# by 2397 in tablespace SYSTEM
To determine the file associated with the tablespace issue the following query in sqlplus:
select file_name, bytes from dba_data_files where tablespace_name = 'SYSTEM';
alter database datafile '<file path and name>' resize <n> alter database datafile '/export/home2/oramnt1/PV/PV_sys_01.dbf' resize 400M
For temporary tablespaces
alter database tempfile '<file path and name>' resize <n>
