Oracle Column Not Allowed Here Default Value <p>The problem is about the DEFAULT value using a sequence on line 4.</p> <pre><code> CREATE OR REPLACE SEQUENCE CHANNEL_SEQ START WITH 1 INCREMENT BY 1; CREATE TABLE "CHANNEL" ( "ID_CHANNEL" NUMBER(18,0) DEFAULT CHANNEL_SEQ.NEXTVAL, "IS_ACTIVE" VARCHAR2(1 CHAR) NOT NULL, "BATCH_SIZE" NUMBER(3,0) NOT NULL, "MAX_DOCS_IN_PROCESS" NUMBER(4,0) NOT NULL, "RECEIVER_ID" NUMBER(18,0) NOT NULL, "LAST_POS_SESSION_TIME" DATE, CONSTRAINT "PK_CHANNEL" PRIMARY KEY ("ID_CHANNEL"), CONSTRAINT "FK_RECEIVER_ID_CHANNEL" FOREIGN KEY ("RECEIVER_ID") REFERENCES "MSG_OUT"("MSG_OUT_ID"), CONSTRAINT "CHK_IS_ACTIVE" CHECK (IS_ACTIVE IN ('Y', 'N')) ); </code></pre> <p>The error messages are : </p> <blockquote> <p>"SQL Error: ORA-00984: column not allowed here"</p> </blockquote> <p>All help and hints are welcome.</p>