Subversion Repositories Sigmater

Rev

Blame | Last modification | View Log | Download | RSS feed

create table WS_ATTRIBUTI_FUNZIONE
(
  COD_ATTRIBUTO NUMBER(10) not null,
  NOME          VARCHAR2(255) not null
)
tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table WS_ATTRIBUTI_FUNZIONE
  add constraint PK_WS_ATTRIBUTI_FUNZIONE primary key (COD_ATTRIBUTO)
  using index 
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
create index I_NOMETTRIBUTO on WS_ATTRIBUTI_FUNZIONE (NOME)
  tablespace &REGMON_TBS_NAME
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );