include a complete CREATE INDEX clause as part of the CREATE TABLE statement
SQL>
SQL> Create table inventory (
2 partno number(4) constraint invent_partno_pk primary key
3 using index (
4 create index invent_part_loc_idx
5 on inventory (partno, warehouse)
6 pctfree 10),
7 partdesc varchar2(35),
8 price number(8,2),
9 warehouse varchar2(15));
Table created.
SQL>
SQL>
SQL> drop table inventory;
Table dropped.
SQL>
Related examples in the same category