Partition based logging and nologging
- From: "Verma, Amit" <Amit.Verma7@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 6 Feb 2007 09:09:30 -0800
Hi All,
Does anyone know the difference between NO and NONE in the logging
column of dba_tab_partitions. 9203 on HP 11.11. Tablespace is in
nologging mode. Table's logging mode is null because it is partitioned.
SQL> select partition_name, logging from dba_tab_partitions where
table_owner='OWN' and table_name='TAB';
PARTITION_NAME LOGGING
------------------------------ -------
D20061229 NO
D20061230 NO
D20061231 NO
D20070101 NO
D20070102 NO
D20070103 NO
D20070104 NO
D20070105 NO
D20070106 NO
D20070107 NO
D20070108 NO
PARTITION_NAME LOGGING
------------------------------ -------
D20070109 NO
D20070110 NO
D20070111 NO
D20070112 NO
D20070113 NO
D20070114 NO
D20070115 NO
D20070116 NO
D20070117 NO
D20070118 NO
D20070119 NONE
PARTITION_NAME LOGGING
------------------------------ -------
D20070120 NONE
D20070121 NONE
D20070122 NONE
D20070123 NONE
D20070124 NONE
D20070125 NONE
D20070126 NONE
D20070127 NONE
D20070128 NONE
D20070129 NONE
D20070130 NONE
PARTITION_NAME LOGGING
------------------------------ -------
D20070131 NONE
D20070201 NONE
D20070202 NONE
D20070203 NONE
D20070204 NONE
D20070205 NONE
D20070206 NONE
D20070207 NONE
D20070208 NONE
D20070209 NONE
43 rows selected.
Amit Verma
ES-DAS Database Administrator
OCP 10g, 9i, 8i, 8 DBA
Other related posts:
- » Partition based logging and nologging
