create table tab_iot ( id integer, col_1 … -- constraint tab_iot_pk primary key(id) ) organization index -- nologging -- pctfree 0 ;
select owner, table_name from all_tables where iot_type is not null;
select seg.blocks, round(seg.bytes / 1024/1024/1024, 2) giga_bytes from user_constraints con join user_segments seg on con.constraint_name = seg.segment_name where con.table_name = 'TABLE_NAME' and con.constraint_type = 'P' ;
$ORACLE_HOME/rdbms/admin/dbmsiotc.sql
.