Oralce常用命令

1:数据库账号被锁

查看被锁账号并解锁

select username,account_status,lock_date from dba_users;
set linesize 9999 
SQL> alter user jack account unlock;

密码过期

SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';

将口令有效期180天修改为无限制

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;```