Re: ORA-1632 max extents reached ..

From: Devinder Pal Singh <Devinder_Pal.Singh_at_pharma.novartis.com>
Date: Fri, 09 Apr 1999 13:22:49 -0400
Message-ID: <370E3768.936860F9@pharma.novartis.com>

No need to go to those lengths.Do the following 1. Export the table with either compress = y or precreate it with large inital extent and import it back.
2) alter the defalut storage of the tablespace and make the maxextents unlimited
Hope it helps.

rsvcool_at_yahoo.com wrote:retain all my data, I am assuming create new tablepsace,

> , assign the same user to this default tablespace, what about the the data
> though ??? sorry of these questions are silly , just want to learn to do it
> right ...
>
> Thanks
> RSV
> rsvcool_at_yahoo.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Apr 09 1999 - 12:22:49 CDT