(→Increase Tablespace Size)
|
(→AutoExtend Tablespace Sizes)
|
Line 29: | |||
To increase the amount of space, locate the file from the previous section and run the following to increase: | 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' AUTOEXTEND ON NEXT 32M MAXSIZE 1024M;</pre> | + | <pre>ALTER DATABASE DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF' AUTOEXTEND ON NEXT 32M |
+ | MAXSIZE 1024M;</pre> | ||
== Drop all Tables/Content Associated with Users == | == Drop all Tables/Content Associated with Users == | ||