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

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

Symptoms

You want to clear data in the orabpel schema in 10.1.3.4 following document:

Oracle BPEL Process Manager Installation Guide 10g Release 3 (10.1.3.1.0) 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 10.1.3.4 or above, but this fails with the error:

ORA-10631 shrink clause should not be specified for this object


This may have worked fine with versions older than 10.1.3.4.

Cause

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