提示用户名密码将要过期时，会导致开启执行计划失效

点击(此处)折叠或打开

1. SQL> show user;
   
2. USER is "SCOTT"
   
3. SQL> explain plan for select * from emp;
   
4. 
   
5. Explained.
   
6. 
   
7. SQL> select * from table(dbms_xplay.display);
   
8. select * from table(dbms_xplay.display)
   
9.                     *
   
10. ERROR at line 1:
    
11. ORA-00904: "DBMS_XPLAY"."DISPLAY": invalid identifier
    
12. 
    
13. 
    
14. SQL> set autot on
    
15. ERROR:
    
16. ORA-24315: illegal attribute type
    
17. 
    
18. 
    
19. SP2-0619: Error while connecting
    
20. SP2-0611: Error enabling STATISTICS report
    
21. SQL> ^C
    
22. 
    
23. SQL>
    
24. SQL>
    
25. 
    
26. SQL> SQL>
    
27. SQL> conn scott/tiger
    
28. ERROR:
    
29. ORA-28002: the password will expire within 4 days
    
30. 
    
31. 
    
32. Connected.
    
33. SQL> set autot on
    
34. ERROR:
    
35. ORA-28002: the password will expire within 4 days
    
36. 
    
37. 
    
38. SP2-0619: Error while connecting
    
39. SP2-0611: Error enabling STATISTICS report
    
40. SQL> conn / as sysdba
    
41. Connected.
    
42. SQL> alter user scott identified by tiger;
    
43. 
    
44. User altered.
    
45. 
    
46. SQL> conn scott/tiger
    
47. Connected.
    
48. SQL> set autot on
    
49. SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/26066458/viewspace-2124299/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/26066458/viewspace-2124299/