Oracle Solution for Error ora-14152

Solution for Oracle Error ORA-14152

ORA-14152: invalid number of partitions specified in PARTITIONS clause

What triggered the Error:

number-of-partitions clause contained in CREATE TABLE or CREATE INDEX statement specified a number of partitions outside of legal range (1-1048575)

What should we do to fix it:

Specify a number between 1 and 1024K-1 in the number-of-partitions clause