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>