RE: Shrink a large table (other options)

>>A lot of indexes? Why??? (Yes, there are legitimate reasons for indexes. But not all indexes necessarily exist for legitimate reasons.)
This is not my goal here to discuss about why many indexes exist. I am not the decision maker on that.

>>Makes one ask, what kind of performance problems are you having? DML or Query?
Select queries only.

>>With a maintenance window, is it possible to drop and recreate the indexes in the allocated time?
Yes, it is possible. That's what I am planning to do.

BA
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Hans Forbrich Sent: Wednesday, January 18, 2017 12:29 PM To: oracle-l_at_freelists.org
Subject: Re: Shrink a large table (other options)

A lot of indexes? Why??? (Yes, there are legitimate reasons for indexes. But not all indexes necessarily exist for legitimate reasons.)

Makes one ask, what kind of performance problems are you having? DML or Query?

With a maintenance window, is it possible to drop and recreate the indexes in the allocated time?

/Hans

On 2017-01-18 1:06 PM, Bheemsen Aitha wrote: Thanks for your reply. Unfortunately we have lot of indexes on that table. Maybe I should just stick with not shrinking it.

BA

ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS'

Our UNDO tablespace size is 32 Gig. Here are the commands I used.

alter table <table name> enable row movement; alter table <table name> shrink space;

I would like to know what are my other options.

Thanks
Bheem Aitha

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