Shulou(Shulou.com)06/01 Report--

Problem description: an error was found when doing mass index migration

ORA-14102: only one LOGGING or NOLOGGING clause can be specified

ODS_STAGE_CRBS [IDX_BANK__BANKCLASS] CREATE INDEX "ODS_STAGE_CRBS". "IDX_BANK__BANKCLASS" ON "ODS_STAGE_CRBS". "T_BANK" ("BANK_CLASS") PCTFREE 10 INITRANS 2 MAXTRANS 255COMPUTE STATISTICS NOLOGGING STORAGE (INITIAL 524288 NEXT 524288 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "CRBSINDEX_TBS" parallel 8 nologgingORA-14102: only one LOGGING or NOLOGGING clause can be specified

The reasons for this problem are:

This error occurs when creating indexes and primary keys on the table when there is no data in the imported table.

There are two solutions:

First, delete the keywords that contain NOLOGGING and LOGGING in the sentence, and then execute them to pass.

Second, install patch: patch 8795792, patch download address:

Http://download.csdn.net/download/wuhan8489/5886065 (provided by netizens, need points)

Reference for solving this article: https://www.cnblogs.com/senyier/p/7681192.html

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.