sys_sysparameter.pdc

来自「用C＃开发的一套数据仓库的代码。（C＃＋ORACLE）」· PDC 代码 · 共 47 行

-- Create table
create table SYS_SYSPARAMETER
(
  PARAMETER_ID   NUMBER(10),
  PARAMETER_CODE VARCHAR2(20) not null,
  PARAMETERDESC  VARCHAR2(200),
  PARAMETERVALUE NUMBER(10),
  ISVALID        VARCHAR2(1)
)
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_SYSPARAMETER
  add constraint SYS_SYSPARAMATER primary key (PARAMETER_CODE)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );
alter table SYS_SYSPARAMETER
  add unique (PARAMETER_ID)
  using index 
  tablespace SYSINFO
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    minextents 1
    maxextents unlimited
  );