gdf_hash_partition on a string category column hashes the category index rather than the underlying string. This can cause a string represented by a category index to be incorrectly partitioned ...

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 ...