ReadSoft: How to extend the XXIT3 tablespace
Summary
17013
Support Article
To extend the XXIT3 tablespace, log into the database management software using an account with system administrator privileges, and then run the following query:
SELECT file_name, Round(bytes / ( 1024 * 1024 )) Mbytes FROM dba_data_files WHERE tablespace_name = 'XXIT3'
An example output will be like the following:
FILE NAME /oracle/te10data/XXIT31.dbf Mbytes 200
Use the following query to change the tablespace size:
ALTER DATABASE datafile '<data file path>' resize <mbytes number>M;
Keywords: Database