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>

oracle 構建索引index_logging_nologging

相關文章