You can assign a default number of partitions to be used when creating partitioned tables. Set the default value on the DBMS configuration parameter default_npartitions, and then specify WITH PARTITION = (rule ON column DEFAULT PARTITIONS) when creating or modifying tables. The table will be partitioned into the configured number of partitions. The default_npartitions parameter can be set to an integer between 0 and 923, inclusive.

The default is 0 (no default available); use partitioning guidelines to set default_npartitions.

The default partition count setting can be overridden at the session level using the SET PARTITION_PARTS statement.