To solve ORA-28001 and ORA-28002, the best way is to follow the rule to change user's password. However, if you had to continue using the… Read More »How to Unexpire Password
SYS.USER$ is a table which stores all user's password information. Generally, the table should be used only by Oracle internal system and not DBA. If… Read More »USER$, 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
Sometimes, you switched the connection to another schema for more operations and forgot where you are. Here are some ways to know who am I… Read More »Oracle Who am I