Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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.
Advertisement
Add Comment
Please, Sign In to add comment