How to resolve Error:- ORA-00907: missing right parenthesis ???

Discussion in 'Databases' started by sreejith, Sep 6, 2010.

0
  1. #1
    Hello All,

    In the following code, while executing the script I am getting the error ORA-00907:- Missing Right Parenthesis.


    CREATE TABLE "Completion_Design_Assumptions"
    (
    "Producing Zone" VARCHAR2(64 BYTE) NOT NULL,
    "Lateral Length" NUMBER(4),
    Frac Stages NUMBER(2) NOT NULL,
    Assumptions VARCHAR2(256 BYTE)
    )
    TABLESPACE USERS
    PCTUSED 0
    PCTFREE 10
    INITRANS 1
    MAXTRANS 255
    STORAGE (
    INITIAL 64K
    MINEXTENTS 1
    MAXEXTENTS 2147483645
    PCTINCREASE 0
    BUFFER_POOL DEFAULT
    )
    LOGGING
    NOCOMPRESS
    NOCACHE
    NOPARALLEL
    MONITORING;

    Please help me to resolve the same.
     
    sreejith, Sep 6, 2010 IP