Delete Table Partition policy.

Posted by Amit Joshi on 05-Jun-2017 04:20

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.

Posted by Jyothi Sundaragiri on 31-Aug-2017 07:18

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

Posted by gus bjorklund on 05-Jun-2017 08:16

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

Posted by Valeriy Bashkatov on 31-Aug-2017 03:43

Hello,

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

Posted by Valeriy Bashkatov on 31-Aug-2017 03:45

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

Posted by Jyothi Sundaragiri on 31-Aug-2017 07:18

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>;

Posted by Valeriy Bashkatov on 31-Aug-2017 08:39

It works.

Thank you!

This thread is closed