CREATE TABLE car_data
02 (
03 car_vendor char(20) not null,
04 car_type char(5) not null,
05 ...
06 )
07 FRAGMENT BY EXPRESSION
08 PARTITION p_audi_a2 (car_vendor = "Audi" and car_type
="A2") in audi_dbs,
09 PARTITION p_audi_a3 (car_vendor = "Audi" and car_type
="A3") in audi_dbs,
10 PARTITION p_audi_a4 (car_vendor = "Audi" and car_type
="A4") in audi_dbs,
11 PARTITION p_audi_a6 (car_vendor = "Audi" and car_type
="A6") in audi_dbs,
12 ...
13 ;