Cannot Execute Shrink on ORABPEL.CUBE_INSTANCE Table in Version 10.1.3.4 or Above: ORA-10631
Last updated on NOVEMBER 03, 2016
Applies to:Oracle(R) BPEL Process Manager 10g - Version 10.1.3.4 and later
Information in this document applies to any platform.
***Checked for relevance on 12-Sep-2011***
***Checked for relevance on 13-Feb-2013***
You want to clear data in the orabpel schema in 10.1.3.4 following document:
Part Number B28980-03
Section: 2.11.4 Dehydration Store Maintenance
This section explains how you can periodically reclaim free space in the dehydration store and manage the future growth of the store.
Oracle recommends that you create the orabpel tablespace with auto segment space management turned
on. This enables you to conveniently reclaim free space in the dehydration store.
With auto segment space management turned on, use the following commands to regain free space (in
this example, for the cube_scope table):
alter table cube_scope enable row movement;
alter table cube_scope shrink space compact;
alter table cube_scope shrink space;
alter table cube_scope disable row movement;
In this case you are executing the above database commands on the table orabpel.cube_instance on version 10.1.3.4 or above, but this fails with the error:
This may have worked fine with versions older than 10.1.3.4.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms