bspkrs

SQL Developer DDL likes to test the engine coders

Jul 29th, 2013
580
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. Error starting at line 3,401 in command:
  2. CREATE UNIQUE INDEX "QA_CIR_PK_MEMBER_PID" ON "QA_CIR_POP_RANKINGS_TOP" ("MEMBER_PID", "SCORE_TYPE_CODE")
  3. PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING COMPUTE STATISTICS NOCOMPRESS LOGGING
  4. TABLESPACE "CIR_INDX"
  5. Error at Command Line:3,402 Column:77
  6. Error report:
  7. SQL Error: ORA-14102: only one LOGGING or NOLOGGING clause may be specified
  8. 14102. 00000 - "only one LOGGING or NOLOGGING clause may be specified"
  9. *Cause: LOGGING was specified more than once, NOLOGGING was specified
  10. more than once, or both LOGGING and NOLOGGING were specified.
  11. *Action: Remove all but one of the LOGGING or NOLOGGING clauses and
  12. reissue the statement.
Advertisement
Add Comment
Please, Sign In to add comment