Re: ORA-1632 max extents reached ..

OR just do this:

alter table <TABLE_NAME> storage (maxextents <NUMBER_OF_MAX_EXTENTS>); OR
alter index <INDEX_NAME> storage (maxextents <NUMBER_OF_MAX_EXTENTS>);

get the idea ?

when you create tables their storage parameters default to tablespace defaults, but it doesn't mean you can not change it later.

+--------------------------------------------------------------------------+
| Vitaliy Mogilevskiy
| Senior Consultant
| CORE Technology Group, Inc.
| E-mail:    vit100gain_at_earthlink.net
| Web Page:  http://home.earthlink.net/~vit100gain/index.html

|            *** Free DBA Script Library at my Web Page ***
+--------------------------------------------------------------------------+

Devinder Pal Singh wrote:

> 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:55:36 CDT