查看用户状态:
col username for a30
col password for a20
col account_status for a30
select username,password,account_status,expiry_date from dba_users;
解锁 hr 用户
alter user hr identified by hr;
alter user hr account unlock;
alter user hr identified by hr account unlock;
重建 scott 用户:
https://blog.51cto.com/3474247/1876399
11G 重建:
SYS@PROD> @?/rdbms/admin/utlsampl.sql
? 表示 $ORACLE_HOME
SYS@PROD> @?/rdbms/admin/utlsampl.sql
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options --表示重建完成,直接登录即可
[oracle@oracle ~]$ sqlplus scott/tiger
SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 18 00:38:44 2019
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SCOTT@PROD>
12CR2 重建:
SYS@PROD> @?/rdbms/admin/utlsampl.sql
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production --表示重建完成
[oracle@ora12c ~]$ sqlplus scott/tiger
SQL*Plus: Release 12.2.0.1.0 Production on Thu May 2 10:04:54 2019
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Last Successful login time: Thu May 02 2019 10:00:54 +08:00
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SCOTT@PROD>