partition delete_test_hash_p1_index_local tablespace PG_DEFAULT, partition delete_test_hash_p2_index_local tablespace PG_DEFAULT, partition delete_test_hash_p3_index_local tablespace PG_DEFAULT INSERT ...
CREATE TABLE sales ( dept_no number, part_no varchar2, country varchar2(20), date date, amount number ) PARTITION BY HASH (part_no) ( PARTITION p1, PARTITION p2, PARTITION p3 ); The table will return ...