Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-10631: what does it mean?

Re: ORA-10631: what does it mean?

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 02 May 2005 14:30:05 +0200
Message-ID: <d5568s$1k1$1@news2.zwoll1.ov.home.nl>


steph wrote:
> Hi,
>
> I issued following command for one of our tables (on behalf of Oracle
> Enterprise Manager's Segment Advisor):
>
> alter table "COREDATA"."SEQ_ANN" shrink space;
>
> The command returns this error:
>
> ORA-10631: SHRINK clause should not be specified for this object
>
> Why shouldn't I?
>
> My system is an Oracle 10.1.0.3.0 database on Suse 9.2
>
> Thanks in advance,
> Stephan
>

Because row movement is not enabled?
Of course, you *could* try to look up the code yourself, in the error messages and codes manual - how appropiate a name...

-- 
Regards,
Frank van Bortel
Received on Mon May 02 2005 - 07:30:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US