create table bricks_hash ( brick_id integer ) partition by /*TODO*/ hash (brick_id) partitions 8; select table_name, partitioned from user_tables where table_name = 'BRICKS_HASH';