ITPub博客

首页 > Linux操作系统 > Linux操作系统 > Oracle中查看哪些objects 是nologging 的

Oracle中查看哪些objects 是nologging 的

原创 Linux操作系统 作者:tolywang 时间:2010-07-15 11:21:34 0 删除 编辑

select  *  from all_tables where    logging='NO'    AND    owner<>'SYS'; 

select  *  from all_indexes where   logging='NO' AND    owner<>'SYS';

 

select * from  ALL_TAB_COLUMNS  where column_name LIKE  '%LOGGING%' ;  

 

SYS,ALL_ALL_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_INDEXES,LOGGING,VARCHAR2,,,3,,,Y,23,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_IND_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,21,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,ALL_IND_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,20,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_LOBS,LOGGING,VARCHAR2,,,7,,,Y,11,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,ALL_LOB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,22,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,ALL_LOB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,22,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_OBJECT_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,ALL_TAB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,21,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,ALL_TAB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,20,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_ALL_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_INDEXES,LOGGING,VARCHAR2,,,3,,,Y,23,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_IND_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,21,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,DBA_IND_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,20,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_LOBS,LOGGING,VARCHAR2,,,7,,,Y,11,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,DBA_LOB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,22,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,DBA_LOB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,22,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_OBJECT_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_TABLES,LOGGING,VARCHAR2,,,3,,,Y,17,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,DBA_TABLESPACES,LOGGING,VARCHAR2,,,9,,,Y,11,,,,,,,,,,,CHAR_CS,9,NO,NO,,9,B,NO,YES
SYS,DBA_TAB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,21,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,DBA_TAB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,20,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_ALL_TABLES,LOGGING,VARCHAR2,,,3,,,Y,16,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_INDEXES,LOGGING,VARCHAR2,,,3,,,Y,22,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_IND_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,20,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,USER_IND_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,19,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_LOBS,LOGGING,VARCHAR2,,,7,,,Y,10,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,USER_LOB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,21,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,USER_LOB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,21,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_OBJECT_TABLES,LOGGING,VARCHAR2,,,3,,,Y,16,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_TABLES,LOGGING,VARCHAR2,,,3,,,Y,16,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES
SYS,USER_TABLESPACES,LOGGING,VARCHAR2,,,9,,,Y,11,,,,,,,,,,,CHAR_CS,9,NO,NO,,9,B,NO,YES
SYS,USER_TAB_PARTITIONS,LOGGING,VARCHAR2,,,7,,,Y,20,,,,,,,,,,,CHAR_CS,7,NO,NO,,7,B,NO,YES
SYS,USER_TAB_SUBPARTITIONS,LOGGING,VARCHAR2,,,3,,,Y,19,,,,,,,,,,,CHAR_CS,3,NO,NO,,3,B,NO,YES

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

请登录后发表评论 登录
全部评论
Oracle , MySQL, SAP IQ, SAP HANA, PostgreSQL, Tableau 技术讨论,希望在这里一起分享知识,讨论技术,畅谈人生 。

注册时间:2007-12-10

  • 博文量
    5595
  • 访问量
    13513265