ORA-00907: missing right parenthesis
Wrong Script
create table ddd.xx_aa_bb
(
a_id varchar2(10 byte) not null,
b_id varchar2(10 byte) default 'NULL' not null,
message varchar2(159 byte)
description varchar2(250 byte)
)
tablespace data_ts
pctused 0
pctfree 10
initrans 1
maxtrans 255
storage (
initial 64k
next 1m
minextents 1
maxextents unlimited
pctincrease 0
buffer_pool default
)
logging
nocompress
nocache
noparallel
monitoring;
--------------------------------------------------------------
Correct Script (missing , at the message field)
create table ddd.xx_aa_bb
(
a_id varchar2(10 byte) not null,
b_id varchar2(10 byte) default 'NULL' not null,
message varchar2(159 byte),
description varchar2(250 byte)
)
tablespace data_ts
pctused 0
pctfree 10
initrans 1
maxtrans 255
storage (
initial 64k
next 1m
minextents 1
maxextents unlimited
pctincrease 0
buffer_pool default
)
logging
nocompress
nocache
noparallel
monitoring;