define schema='schema_name'
create table &schema..tblname (
col1name number constraint tblname_1_nn not null,
col2name char(n) constraint tblname_2_nn not null,
col3name varchar2(n) constraint tblname_3_nn not null,
constraint tblname_0_pk
primary key (col1name)
using index tablespace index_tspname
pctfree 5
initrans 1
maxtrans 255
storage (
initial 1k
minextents 1
maxextents unlimited
)
)
tablespace data_tspname
pctfree 5
initrans 1
maxtrans 255
storage (
initial 4k
minextents 1
maxextents unlimited
);
grant select, insert, update, delete
on &schema..tblname
to rolename1,
rolename2;
Home > Computers > Databases > Oracle > DDL > Create Table
Viewing mobile website page. Switch to WML or Full HTML