My Oracle Support Banner

Cannot Execute Shrink on ORABPEL.CUBE_INSTANCE Table in Version or Above: ORA-10631 (Doc ID 948898.1)

Last updated on OCTOBER 21, 2021

Applies to:

Oracle(R) BPEL Process Manager 10g - Version 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 following document:

Oracle BPEL Process Manager Installation Guide 10g Release 3 ( for UNIX and Microsoft Windows
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 or above, but this fails with the error:

This may have worked fine with versions older than


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.