sys_page.~pdc

用C＃开发的一套数据仓库的代码。（C＃＋ORACLE）

-- Create table
create table SYS_PAGE
(
  PAGE_ID           NUMBER(10) not null,
  PAGE_CODE         VARCHAR2(20),
  APP_CODE          VARCHAR2(20),
  PAGETYPE_CODE     VARCHAR2(20),
  PAGEDESC          VARCHAR2(200),
  SPECNUM           NUMBER(10),
  PAGE_FILE         BLOB,
  ISVALID           VARCHAR2(1),
  PAGEPATH          VARCHAR2(200),
  UPDATEDATE        DATE,
  UPDATEBYUSER_CODE VARCHAR2(20)
)
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_PAGE
  add constraint PK_SYS_PAGE primary key (PAGE_ID)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table SYS_PAGE
  add unique (PAGE_CODE)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );