|
(→Get Current Tablespace Size)
|
(→Increase Tablespace Size)
|
| Line 91: | |||
| 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' resize 2048M;</pre> | <pre>ALTER DATABASE DATAFILE 'C:\ORACLEXE\APP\ORACLE\ORADATA\XE\SYSTEM.DBF' resize 2048M;</pre> | ||
| + | == Drop all Tables/Content Associated with Users == | ||
| + | Unlike other database types, Oracle doesn't have a concept of 'individual databases.' Instead, it uses one database with different users/views. If you drop a user, all content associated with them will be removed (equivalent to MySQL's DROP DATABASE). To perform this: | ||
| + | <pre>DROP USER testuser CASCADE;</pre> | ||
