-- Create table
create table WORKINGSCHEDULE
(
WORKINGSCHEDULEID NUMBER not null,
DESCRIPTION VARCHAR2(50),
HASLD NUMBER not null,
CUSTSCHEDULEID NUMBER,
CUSTSTARTTIME DATE,
CUSTENDTIME DATE,
ROWSTAMP VARCHAR2(40) not null
)
tablespace MAXIMO
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Create/Recreate indexes
create unique index WORKINGSCHED_NDX1 on WORKINGSCHEDULE (WORKINGSCHEDULEID)
tablespace MAXIMO
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create table WORKINGSCHEDULE
(
WORKINGSCHEDULEID NUMBER not null,
DESCRIPTION VARCHAR2(50),
HASLD NUMBER not null,
CUSTSCHEDULEID NUMBER,
CUSTSTARTTIME DATE,
CUSTENDTIME DATE,
ROWSTAMP VARCHAR2(40) not null
)
tablespace MAXIMO
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Create/Recreate indexes
create unique index WORKINGSCHED_NDX1 on WORKINGSCHEDULE (WORKINGSCHEDULEID)
tablespace MAXIMO
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货