|
(→Quick Reference SQL for Oracle XE)
|
(→Get Current Tablespace Size)
|
| Line 86: | |||
| from dba_extents a,dba_data_files b where a.file_id=b.file_id group by | from dba_extents a,dba_data_files b where a.file_id=b.file_id group by | ||
| a.file_id,b.file_name, autoextensible,b.bytes/1024/1024;</pre> | a.file_id,b.file_name, autoextensible,b.bytes/1024/1024;</pre> | ||
| + | == Increase Tablespace Size == | ||
| + | To increase the amount of space, locate the file from the previous section and run the following to increase: | ||
| + | <pre>ALTER DATABASE DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF' resize 2048M;</pre> | ||
