Delete Table Partition policy. - Forum - OpenEdge RDBMS - Progress Community

Delete Table Partition policy.

 Forum

Delete Table Partition policy.

This question is answered

I want to remove all table partitioning defined for a table and revert to non-partitioned table. Whole table dump load (data/df) not possible in my case. Docs says deleting/removing partition is possible but there is no mentions how to do it.

Verified Answer
  • To delete and remove partition, please use the commands specified below :

    echo y | proutil testdb -C partitionmanage truncate table <table_name> partition  <partition_name> deallocate

    SQL command to drop a partition:

    Alter Table <table_name> Drop Partition <partition_name>;
    
All Replies
  • Have a look at the proutil partition merge function.

    Here is an example from one of my scripts:

    proutil atm -C partitionmanage merge table history1 \

    partition histp01 partition histp09 partition histp10 \

    recs 1000

  • Hello,

    Merge cannot merge a list partition - how to delete list partition?

  • All partition in the deallocated state.

    I also can not delete this table from schema

    Because:

    "Removing the definition for "Customer"...

    You can only delete a _File row once you have deleted any related _Partition-Policy rows. (16008)"

    P.S.

    OpenEdge 11.5? Linux 64

  • To delete and remove partition, please use the commands specified below :

    echo y | proutil testdb -C partitionmanage truncate table <table_name> partition  <partition_name> deallocate

    SQL command to drop a partition:

    Alter Table <table_name> Drop Partition <partition_name>;
    
  • It works.

    Thank you!