-- Create table
create table IT_T1
(
id NUMBER not null,
fruit VARCHAR2(20),
quantity NUMBER,
created_date DATE
)
tablespace DATOS
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table IT_T1
add constraint IT_T1_PK primary key (ID)
using index
tablespace DATOS
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);