Is it possible to create a table and partition it (by range) on a column that is a “date value” but the datatype is character (character string).
Due to vendor restrictions, we are using character datatype to store date and I am running into ORA-00907 when I try to create a partition table by range on that column.