I was going through test cases where I came to know that If a table partitioned for particular column and somebody try to push null value into it.
It throws error "ORA-14300: partitioning key maps to a partition outside maximum permitted number of partitions"
Randomly I've gone through some article on internet I found more of the comments inclined towards that the error raised because
Partition is implemented to improve performance and null values depreciate performance.
Is this statement is true or is there workaround for it or shall we stick to not insert null values into partitioned table.
I wanted to learn designing perspective.