• 先打11.2.0.3.8这个PSU,后建库


    SQL> alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
    
    Session altered.
    
    SQL> select created from v$database;
    
    CREATED
    ------------------------------------------------------------------------------------------------------------------------
    2015-06-10 13:31:51                         ------------->库的建立时间
    
    SQL> set pages 100 lines 120
    SQL> col action format a6
    SQL> col namespace format a10
    SQL> col version format a10
    SQL> col comments format a15
    SQL> col action_time format a30
    SQL> col bundle_series format a15
    SQL> alter session set nls_timestamp_format = 'yyyy-mm-dd hh24:mi:ss.ff';
    
    Session altered.
    
    SQL> 
    SQL> select * from dba_registry_history;
    
    ACTION_TIME                    ACTION NAMESPACE  VERSION            ID BUNDLE_SERIES   COMMENTS
    ------------------------------ ------ ---------- ---------- ---------- --------------- ---------------
    2011-09-17 10:21:11.595816     APPLY  SERVER     11.2.0.3            0 PSU             Patchset 11.2.0.2.0
    2015-06-10 13:36:01.203202     APPLY  SERVER     11.2.0.3            8 PSU             PSU 11.2.0.3.8------------->PSU的应用时间
    
    


     

  • 相关阅读:
    学习进度
    作业8:单元测试练习
    用户体验设计案例分析
    团队协作一
    需求分析
    结对编程——词频统计 2
    结对编程——词频统计
    个人项目-词频统计
    数组求和
    个人介绍和Github使用流程
  • 原文地址:https://www.cnblogs.com/brucemengbm/p/7402714.html
Copyright © 2020-2023  润新知