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
ORA-28002
How Oracle Alter User Password Expire
Expire User Password In this post, we introduce two ways to expire an user's password in N days. The first one provides no grace time,… Read More »How Oracle Alter User Password Expire
How to Resolve UDI-28002: operation generated ORACLE error 28002
UDI-28002 Saw error UDI-28002 when using expdp or impdp to migrate data. UDI-28002: operation generated ORACLE error 28002 ORA-28002: the password will expire within 7… Read More »How to Resolve UDI-28002: operation generated ORACLE error 28002
How to Resolve ORA-17629: Cannot connect to the remote database server
ORA-17629 ORA-17629 means that it cannot connect to the remote database because of some underlying errors occurred, most likely, there're some error returned. In the… Read More »How to Resolve ORA-17629: Cannot connect to the remote database server
How to Resolve ORA-28002: the password will expire within 7 days
ORA-28002 ORA-28002 means that the password of the user will expire soon in N days, although the user is allowable to connect to the database.… Read More »How to Resolve ORA-28002: the password will expire within 7 days
How to Set Password Never Expire
PASSWORD_LIFE_TIME UNLIMITED The password expiration notice is actually an Oracle error, ORA-28002: the password will expire within days. To avoid the error, we have to… Read More »How to Set Password Never Expire