SQL> 
SQL> drop table part_range_iot;

Table dropped.

SQL> 
SQL> -- Range
SQL> create table part_range_iot (c1 number(3), c2 varchar2(2), c3 char(1),
  2   constraint  part_range_iot_pk primary key (c1))
  3  organization index
  4  partition by range (c1)
  5  (partition p1 values less than (100),
  6   partition p2 values less than (200),
  7   partition p3 values less than (300)
  8  )
  9  ;

Table created.

SQL> 
SQL> drop table part_range_iot;

Table dropped.

SQL> 
SQL> -- Hash
SQL> create table part_range_iot (c1 number(3), c2 varchar2(2), c3 char(1),
  2   constraint  part_range_iot_pk primary key (c1))
  3  organization index
  4  partition by hash (c1) partitions 4
  5  ;

Table created.

SQL> 
SQL> drop table part_range_iot;

Table dropped.

SQL> 
SQL> -- Can not use IOT with list partitioning, ORACLE 9.2.0.1
SQL> create table part_range_iot (c1 number(3), c2 varchar2(2), c3 char(1),
  2   constraint  part_range_iot_pk primary key (c1))
  3  organization index
  4  partition by range (c1)
  5  subpartition by list (c2)
  6  (partition p1 values less than (100),
  7   partition p2 values less than (200)
  8   (subpartition p2_d1 values('A'),
  9    subpartition p2_d2 values('B')
 10   ),
 11  partition p3 values less than (300)
 12   (subpartition p3_d1 values('A'),
 13    subpartition p3_d2 values('B')
 14   )
 15  )
 16  ;
(partition p1 values less than (100),
*
ERROR at line 6:
ORA-25198: only range and hash partitioning are supported for index-organized 
table 


SQL> 
SQL> -- You cannot specify the composite_partitioning_clause for an index-organized table
SQL> create table part_range_iot (c1 number(3), c2 varchar2(2), c3 char(1),
  2   constraint  part_range_iot_pk primary key (c1))
  3  organization index
  4  partition by range (c1)
  5  subpartition by hash (c2)
  6  subpartitions 4
  7  (partition p1 values less than (100),
  8   partition p2 values less than (200),
  9   partition p3 values less than (300)
 10  )
 11  ;
subpartitions 4
*
ERROR at line 6:
ORA-25198: only range and hash partitioning are supported for index-organized 
table 


SQL> 
SQL> create table part_range_iot (c1 number(3), c2 varchar2(2), c3 char(1),
  2   constraint  part_range_iot_pk primary key (c1))
  3  organization index
  4  partition by range (c1)
  5  (partition p1 values less than (100),
  6   partition p2 values less than (200),
  7   partition p3 values less than (300)
  8  )
  9  ;

Table created.

SQL> 
SQL> -- If no tablespace is specified, it remains in the same tablespace.
SQL> -- No online allowed with IOT partition
SQL> alter table part_range_iot move partition p1 online;
alter table part_range_iot move partition p1 online
                                             *
ERROR at line 1:
ORA-14020: this physical attribute may not be specified for a table partition 


SQL> 
SQL> alter table part_range_iot move partition p1;

Table altered.

SQL> 
SQL> spool off