USER_ASTATUS_MAP, How and Why
SYS.USER_ASTATUS_MAP provides a list of account status bit and their definitions. Let's see its content. In which, ASTATUS stands for "Account STATUS". SQL> show user… Read More »USER_ASTATUS_MAP, How and Why
DBA_USERS
Drop Tablespace Examples
We take the following steps to drop a tablespace. 1. Make Sure Non-Default The tablespace that we want to drop must not be the default… Read More »Drop Tablespace Examples
Oracle Default User
Predefined and Customized Users Although we can look up the predefined accounts in the official documentation to make sure that we won't touch them in… Read More »Oracle Default User
How to Resolve ORA-65096: invalid common user or role name
ORA-65096 Tried to add a user to the database, but it failed with ORA-65096. SQL> create user hr; create user hr … Read More »How to Resolve ORA-65096: invalid common user or role name
How to Resolve ORA-28001: the password has expired
ORA-28001 ORA-28001 means that your password has been expired according to your profile. Normally, you should change the password, but you can still work around… Read More »How to Resolve ORA-28001: the password has expired
How to Resolve ORA-28000: The account is locked
ORA-28000 ORA-28000 means that the account that you tried to use is locked because some privileged user disabled the ability of connection, or attempt connections… Read More »How to Resolve ORA-28000: The account is locked