|
(→Increase Tablespace Size)
|
(→Drop all Tables/Content Associated with Users)
|
| Line 96: | |||
| 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: | 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> | <pre>DROP USER testuser CASCADE;</pre> | ||
| + | == Altering Passwords == | ||
| + | Run the following to change the password of a user: | ||
| + | <pre>ALTER USER testuser IDENTIFIED BY newpassword;</pre> | ||
