RE: Comparing apples to apples on Exadata

        You probably have a functional index on that table. You will need to drop it and recreate it.

Liz

Elizabeth Reen
CPB Database Group Manager
718.248.9930  (Office)
Service Now Group: CPB-ORACLE-DB-SUPPORT

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Will Beldman Sent: Monday, December 18, 2017 5:36 PM
To: oracle-l_at_freelists.org
Subject: Re: Comparing apples to apples on Exadata

For the wayward googler, I can not shrink because the table has functional indexes.

I'll have to drop them, do the shrink, and recreate the indexes. Not sure if it will resolve my issue but it will definitely help.

On Monday December 18 2017 04:09:30 PM Will Beldman wrote:
> I checked the segment advisor and I think this might be coming in to
> play as well.
>
> Database 1 shows no problems.
>
> Database 2 shows the table is 49.00% chained rows and recommends a shrink:
> Reclaimable Space (MB):
> 1,362.83
>
> Allocated Space (MB):
> 3,458.00
>
> Used Space (MB):
> 2,095.17
>
> I tried to execute a shrink on the table on Database 2 but I get:
> ======================
> begin
> EXECUTE IMMEDIATE 'alter table "SYSADM"."##TABLE_NAME##" enable row
> movement'; EXECUTE IMMEDIATE 'alter table "SYSADM"."##TABLE_NAME##"
> shrink space'; end; Error report -
> ORA-10631: SHRINK clause should not be specified for this object
> ORA-06512: at line 3
> 10631. 00000 - "SHRINK clause should not be specified for this object"
> *Cause: It is incorrect to issue shrink on the object
> *Action: Verify the object name and type and reissue the command
> ======================
> ?!
> (and yes, I have the right object name. ##TABLE_NAME## is just a
> placeholder I'm putting in this thread.)

--
https://urldefense.proofpoint.com/v2/url?u=http-3A__www.freelists.org_webpage_oracle-2Dl&d=DwICAg&c=j-EkbjBYwkAB4f8ZbVn1Fw&r=yWMFosURAngbt8VLeJtKLVJGefQxustAZ9UxecV7xpc&m=Daa46H1iz6dLzh1HmPa5O9Z-N1gTaa__r9UCBt6nqXE&s=xHfjWVUs_YsFK0qOvuXctkNtGAfpySU-cc5Dta6GxTU&e=


--
http://www.freelists.org/webpage/oracle-l