create table temp_0001(
Field1 varchar2(1000) not null,
Fiels2 varchar2(10000)
)
tablespace data0001 pctfree 10initrans 1
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table temp_0001
add constraint PK_ Field1 primary key(Field1)
using index
tablespace temp_INDEX
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);