| 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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
