-- Create table
create table SYS_PAGETYPE
(
  PAGETYPE_ID   NUMBER(10) not null,
  PAGETYPE_CODE VARCHAR2(20),
  PAGETYPEDESC  VARCHAR2(200)
)
tablespace SYSINFO
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
-- Create/Recreate primary, unique and foreign key constraints 
alter table SYS_PAGETYPE
  add constraint PK_SYS_PAGETYPE primary key (PAGETYPE_ID)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table SYS_PAGETYPE
  add unique (PAGETYPE_CODE)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );