分享一下我老师大神的人工智能教程!零基础,通俗易懂!http://blog.csdn.net/jiangjunshow
也欢迎大家转载本篇文章。分享知识,造福人民,实现我们中华民族伟大复兴!
一、当前ORACLE用户的状态可查看视图DBA_USERS;一般情况下在使用的正常用户均处于OPEN状态。
1 | SQL> select username,account_status from dba_users; |
2 | USERNAME ACCOUNT_STATUS |
3 | --------------------- ------------------ |
4 | MGMT_VIEW OPEN |
5 | SYS OPEN |
6 | SYSTEM OPEN |
7 | DBSNMP OPEN |
8 | SYSMAN OPEN |
9 | DEMO OPEN |
10 | OUTLN EXPIRED & LOCKED |
11 | MDSYS EXPIRED & LOCKED |
12 | ORDSYS EXPIRED & LOCKED |
13 | ANONYMOUS EXPIRED & LOCKED |
14 | EXFSYS EXPIRED & LOCKED |
15 | WMSYS EXPIRED & LOCKED |
16 | XDB EXPIRED & LOCKED |
17 | ORDPLUGINS EXPIRED & LOCKED |
18 | SI_INFORMTN_SCHEMA EXPIRED & LOCKED |