Subversion Repositories Sigmater

Rev

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 &REGMON_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 &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
grant select on WS_ENTI to &MONIT_USER_NAME;