一个例子:
-- Create table
create table tablename
(
......
......
)
tablespace tablespacename
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 536K
next 536K
minextents 1
maxextents 505
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table tablename
add primary key (column name)
using index
tablespace tablespacename
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 1M
next 1M
minextents 1
maxextents 505
pctincrease 1
);
-- Grant/Revoke object privileges
grant select, insert, update, delete, references, alter, index on
yourtable to User;
grant select on yourtable to ROLE_EXECUTE;
-- Create table
create table tablename
(
......
......
)
tablespace tablespacename
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 536K
next 536K
minextents 1
maxextents 505
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table tablename
add primary key (column name)
using index
tablespace tablespacename
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 1M
next 1M
minextents 1
maxextents 505
pctincrease 1
);
-- Grant/Revoke object privileges
grant select, insert, update, delete, references, alter, index on
yourtable to User;
grant select on yourtable to ROLE_EXECUTE;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货