oracle 构建索引index_logging_nologging

SQL> create table t_index(a int,b int);

Table created.

 

SQL> create index idx_t_index on t_index(a);

Index created.

 

 

SQL> select index_name,logging,status from user_indexes where table_name='T_INDE
X';

INDEX_NAME                     LOGGING   STATUS
------------------------------ --------- --------
IDX_T_INDEX                    YES       VALID

 

 

SQL> drop index idx_t_index;

Index dropped.

 

 

SQL> create index idx_t_index on t_index(a) nologging;

Index created.

 

 

 

SQL> select index_name,logging,status from user_indexes where table_name='T_INDE
X';

INDEX_NAME                     LOGGING   STATUS
------------------------------ --------- --------
IDX_T_INDEX                    NO        VALID

SQL>

 

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

转载于:http://blog.itpub.net/9240380/viewspace-752182/