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