1.找到scott.sql脚本
C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin\scott.sql
2.在sqlplus中,用sys用户登录,执行脚本
conn sys/密码 as sysdba
@C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin\scott.sql
3.解锁用户
alter user scott account unlock;
4.重置密码
alter user scott identified by tiger;
5.scott账户可以登录了
conn scott/tiger
C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin\scott.sql
2.在sqlplus中,用sys用户登录,执行脚本
conn sys/密码 as sysdba
@C:\oraclexe\app\oracle\product\11.2.0\server\rdbms\admin\scott.sql
3.解锁用户
alter user scott account unlock;
4.重置密码
alter user scott identified by tiger;
5.scott账户可以登录了
conn scott/tiger