For unique-index partitioned tables, you can use the range, list, or hash-partitioning method. To create a unique ROWID for the partitioned table, you must set the parameter default_with_rowids = true.
This example creates a partitioned table sales using the PARTITION BY LIST clause. The sales table stores information in three partitions: europe, asia, and americas.
The table is partitioned by the value specified in the country column:
Insert values into the sales table:
This query shows that a unique index is created for the sales table:
Querying the contents of the sales_europe confirms that the unique index is created for the table: