Skip to main content

ReadSoft: How to extend the XXIT3 tablespace



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