Blame | Last modification | View Log | Download | RSS feed
create table WS_ENTI
(
ID NUMBER not null,
ID_PADRE NUMBER,
NOME VARCHAR2(250),
FLAG_SEGNAPOSTO NUMBER(1),
CODICE_BELFIORE_ENTE VARCHAR2(50),
NOTE VARCHAR2(200)
)
tablespace ®MON_TBS_NAME
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
alter table WS_ENTI
add constraint PK_WS_ENTI primary key (ID)
using index
tablespace ®MON_TBS_NAME
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
grant select on WS_ENTI to &MONIT_USER_NAME;