建表

-- Create table
create table SKM.SKM_PII_REQ_HEADER
(
NEEDED_BY_DATE DATE not null,
REQUESTED_DATE DATE,
CREATED_BY NUMBER(15) not null,
CREATION_DATE DATE not null,
LAST_UPDATED_BY NUMBER(15) not null,
LAST_UPDATE_DATE DATE not null,
)
tablespace SHAREDD
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 40K
next 128K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table SKM.SKM_PII_REQ_HEADER
add constraint SKM_PII_REQ_HEADER_PK primary key (PSR_ID)
using index
tablespace SHAREDX
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 40K
next 128K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Grant/Revoke object privileges
grant select, insert, update, delete, alter on SKM.SKM_PII_REQ_HEADER to APPS with grant option;
grant select, insert, update, delete, alter on SKM.SKM_PII_REQ_HEADER to EDELIVERY;
grant select, insert, update, delete on SKM.SKM_PII_REQ_HEADER to SAD;