Max extent reached [message #193919] |
Tue, 19 September 2006 23:22 |
fakhar55
Messages: 99 Registered: September 2005 Location: UAE
|
Member |
|
|
hi all,
ORA-01631: max # extents (505) reached in table GL.GL_INTERFACE_TRK when inserting new rows. How to remove this any help will be greatly appreciated.
|
|
|
Re: Max extent reached [message #193992 is a reply to message #193919] |
Wed, 20 September 2006 05:50 |
kimant
Messages: 201 Registered: August 2006 Location: Denmark
|
Senior Member |
|
|
alter table <table-name> storage (maxextents unlimited);
or
alter table <table-name> storage (maxextents 1000);
Br
Kim Anthonisen
|
|
|
|