ORA-00922: missing or invalid option

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • chuckbartowski
    New Member
    • Mar 2015
    • 1

    ORA-00922: missing or invalid option

    Hi Everyone,

    Please help me on this. Thanks.

    Code:
    CREATE TABLE PREMIA_BONUS_REF
    (
      PC_CODE           VARCHAR2(50)                  ,
      POL_PROD_CODE     VARCHAR2(50)                  ,
      POBH_MKT_CODE     VARCHAR2(50)                  ,
      AGENT_RANK_DESC   VARCHAR2(50)                  ,
      BONUS_RATE        NUMBER(14,3)
      START_DATE        DATE,
      END_DATE          DATE,
      CREATED_ON        DATE                          default sysdate,
      CREATED_BY        VARCHAR2(30)                  default user,
      MODIFIED_ON       DATE                          default sysdate,
      MODIFIED_BY       VARCHAR2(30)                  default user,
    )
    TABLESPACE FFCCPOL
    PCTUSED    40
    PCTFREE    10
    INITRANS   1
    MAXTRANS   255
    STORAGE    (
                INITIAL          20K
                MINEXTENTS       1
                MAXEXTENTS       2147483645
                PCTINCREASE      0
                FREELISTS        1
                FREELIST GROUPS  1
                BUFFER_POOL      DEFAULT
               )
    LOGGING 
    NOCACHE
    NOPARALLEL
    Last edited by Rabbit; Mar 16 '15, 04:50 PM. Reason: Please use [code] and [/code] tags when posting code or formatted data.
Working...