Re: ORA-1632 Max # extents 505 reached in table A

Hi,

The easiest way is:

1.export table, make sure compress=y
2.drop table
3.import table

All data will be compress to one extent.

If it can't resolve your problem, following command should be issued to extend size of next extent.
Alter table .. storage ( next ...);

Hopefully, it's helpful for you.

Regards

Hai Bo

In article
<G9uf3.1534$jl.11270641_at_newscontent-01.sprint.ca>,   "Huy Vu" <huyv_at_usa.net> wrote:
> Hi all,
>
> Should I increase the size of the tablespace or
something else to fix this
> error message.
>
> Thanks in advance for any help...
>
> H.V
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Mon Jul 05 1999 - 05:01:38 CDT