RDBMS Non-Partitioned Table to a Partitioned Table in Oracle Database

Hi

we are facing performance issue for the below mentioned table we try to create the partition for PS_LEDGER table but unfortunately unable to create the partition

below requirement for the application team

We want to start testing the performance improvement after that?

We are looking for partition on fiscal year & accounting period

My suggestion was :-

-----------------------------------------------

History data till 2018 in one partition

One Partition for previous year

12 partition each for calender month in current year.

Aprox 14 partitions we can start with.

partition on fiscal year & accounting period

SQL> SELECT partition_name, num_rows FROM  user_tab_partitions WHERE table_name = 'PS_LEDGER';