SQL Developer DDL likes to test the engine coders

text |

700 B

None

0 👍

0 👎

Raw Download Clone Embed Print View

Error starting at line 3,401 in command:
CREATE UNIQUE INDEX "QA_CIR_PK_MEMBER_PID" ON "QA_CIR_POP_RANKINGS_TOP" ("MEMBER_PID", "SCORE_TYPE_CODE") 
  PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING COMPUTE STATISTICS NOCOMPRESS LOGGING
  TABLESPACE "CIR_INDX" 
Error at Command Line:3,402 Column:77
Error report:
SQL Error: ORA-14102: only one LOGGING or NOLOGGING clause may be specified
14102. 00000 -  "only one LOGGING or NOLOGGING clause may be specified"
*Cause:    LOGGING was specified more than once, NOLOGGING was specified
           more than once, or both LOGGING and NOLOGGING were specified.
*Action:   Remove all but one of the LOGGING or NOLOGGING clauses and
           reissue the statement.

Pasted

SQL Developer DDL likes to test the engine coders

Comments