|
(Reordering the data for easier flow)
|
(→Increase Tablespace Size)
|
| Line 21: | |||
| <pre>ALTER DATABASE DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF' resize 2048M;</pre> | <pre>ALTER DATABASE DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF' resize 2048M;</pre> | ||
| + | == Add Datafile to Tablespace == | ||
| + | To increase the amount of space, add another available file to the tablespace: | ||
| + | <pre>ALTER TABLESPACE ADD DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM1.DBF' size 1024M;</pre> | ||
| + | == AutoExtend Tablespace Sizes == | ||
| + | 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> | ||
| == Drop all Tables/Content Associated with Users == | == Drop all Tables/Content Associated with Users == | ||
