提示用户名密码将要过期时，会导致开启执行计划失效
点击(此处)折叠或打开
-
SQL> show user;
-
USER is "SCOTT"
-
SQL> explain plan for select * from emp;
-
-
Explained.
-
-
SQL> select * from table(dbms_xplay.display);
-
select * from table(dbms_xplay.display)
-
*
-
ERROR at line 1:
-
ORA-00904: "DBMS_XPLAY"."DISPLAY": invalid identifier
-
-
-
SQL> set autot on
-
ERROR:
-
ORA-24315: illegal attribute type
-
-
-
SP2-0619: Error while connecting
-
SP2-0611: Error enabling STATISTICS report
-
SQL> ^C
-
-
SQL>
-
SQL>
-
-
SQL> SQL>
-
SQL> conn scott/tiger
-
ERROR:
-
ORA-28002: the password will expire within 4 days
-
-
-
Connected.
-
SQL> set autot on
-
ERROR:
-
ORA-28002: the password will expire within 4 days
-
-
-
SP2-0619: Error while connecting
-
SP2-0611: Error enabling STATISTICS report
-
SQL> conn / as sysdba
-
Connected.
-
SQL> alter user scott identified by tiger;
-
-
User altered.
-
-
SQL> conn scott/tiger
-
Connected.
-
SQL> set autot on
- SQL>
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26066458/viewspace-2124299/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
数据库对象
请登录后发表评论
登录
全部评论
