创建没指定logging_clause 的分区索引
SQL> CREATE INDEX prod_idx ON hash_products(category_id) LOCAL STORE IN (tbs_01, test_space);
Index created.
查看 user_indexes 视图的logging值是空,user_indexes 视图可以查看非分区索引的logging属性
SQL> select index_name,partitioned,logging from user_indexes where index_name='PROD_IDX';
INDEX_NAME PARTITIONED LOG
------------------------------ --------------- ---
PROD_IDX YES
创建非分区索引
SQL> drop index PROD_IDX;
Index dropped.
SQL> CREATE INDEX prod_idx ON hash_products(category_id);
Index created.
SQL> select index_name,partitioned,logging from user_indexes where index_name='PROD_IDX';
INDEX_NAME PARTITIONED LOG
------------------------------ --------------- ---
PROD_IDX NO YES
user_part_indexes 视图的def_logging字段标识创建分区索引时是否指定了logging_clause ,以及指定的是logging还是nologging
如果没指定logging_clause,def_logging的值是 NONE
SQL> select index_name,def_logging from user_part_indexes where index_name='PROD_IDX';
INDEX_NAME DEF_LOG
------------------------------ -------
PROD_IDX NONE
如果指定logging_clause是logging或者nologging,def_logging的值是YES 或者NO
创建分区索引指定logging_clause 是logging
------------------------------ -------
PROD_IDX YES
------------------------------ -------
PROD_IDX NO
------------------------------ --------------- ---
PROD_IDX YES
------------------------------ -------
PROD_IDX NONE
------------------------------ ------------------------------ -------
PROD_IDX TBS_01 YES
PROD_IDX TEST_SPACE YES
SQL> select tablespace_name,logging from user_tablespaces where tablespace_name='TEST_SPACE';
------------------------------ ---------
TEST_SPACE LOGGING
SQL> select tablespace_name,logging from user_tablespaces where tablespace_name='TBS_01';
------------------------------ ---------
TBS_01 LOGGING
创建分区索引时没有指定logging_clause,分区索引的每个分区的默认值是logging
SQL> drop index PROD_IDX;
------------------------------ ------------------------------ -------
PROD_IDX TBS_01 YES
PROD_IDX TEST_SPACE YES
SQL> select tablespace_name,logging from user_tablespaces where tablespace_name='TBS_03';
------------------------------ ---------
TBS_03 NOLOGGING
------------------------------ ---------
TBS_04 NOLOGGING
创建分区索引时没有指定logging_clause,分区索引的每个分区的默认值nologging
SQL> drop index prod_idx;
------------------------------ ------------------------------ -------
PROD_IDX TBS_03 NO
PROD_IDX TBS_04 NO
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/24756186/viewspace-742774/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/24756186/viewspace-742774/