Discussion Locked

Max Extents increase

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Any ideas how to raise max extents of tables within Oracle database?

thanks

5 replies

by d. brinson

You must have security to alter the table. If you do, the following command should work:

alter table TABLENAME storage (maxextents NEW_VALUE);

where TABLENAME is the name of your table
and NEW_VALUE is your new extent size (for example 5 or200

If you use scripts to create your database, you must be sure to change the scripts to reflect your new extent size.

This discussion is closed to new replies.