Create a table with ORGANIZATION INDEX
SQL>
SQL>
SQL>
SQL> create table addresses
2 ( empno number(4),
3 addr_type varchar2(10),
4 street varchar2(20),
5 city varchar2(20),
6 state varchar2(2),
7 zip number,
8 primary key (empno,addr_type)
9 )
10 ORGANIZATION INDEX
11 /
Table created.
SQL>
SQL> drop table addresses;
Table dropped.
SQL>
SQL> --
Related examples in the same category