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