SQL> CREATE TABLESPACE sf1 DATAFILE 'sf1.dbf' SIZE 40M ONLINE;
Tablespace created.
SQL> CREATE TABLESPACE sf2 DATAFILE 'sf2.dbf' SIZE 40M ONLINE;
Tablespace created.
SQL> CREATE TABLESPACE sf3 DATAFILE 'sf3.dbf' SIZE 40M ONLINE;
Tablespace created
SQL> CREATE TABLE part_sales_tab_mv(time_id, cust_id, sum_dollar_sales, sum_unit_sale)
2 PARALLEL PARTITION BY RANGE (time_id)
3 (PARTITION month1
4 VALUES LESS THAN (TO_DATE('31-12-1998', 'DD-MM-YYYY'))
5 PCTFREE 0 PCTUSED 99
6 STORAGE (INITIAL 64k NEXT 16k PCTINCREASE 0)
7 TABLESPACE sf1,
8 PARTITION month2
9 VALUES LESS THAN (TO_DATE('31-12-1999', 'DD-MM-YYYY'))
10 PCTFREE 0 PCTUSED 99
11 STORAGE (INITIAL 64k NEXT 16k PCTINCREASE 0)
12 TABLESPACE sf2,
13 PARTITION month3