Q
Problem solve Get help with specific problems with your technologies, process and projects.

Altering maxextents

I would like to know about how to alter maxextents in Oracle.

To modify the maxextents for an object, you'll need to know if it is a table or an index. I'll show you how to do this for a table. It is similar for an index.

You'll want to use the ALTER TABLE command to modify the storage characteristics of the table. For instance:

ALTER TABLE my_table 
STORAGE( maxextents 505 ); 
Substitute the appropriate number of maximum extents for '505' in the above command.

For More Information


Dig Deeper on Oracle database design and architecture

SearchDataManagement
SearchBusinessAnalytics
SearchSAP
SearchSQLServer
TheServerSide.com
SearchDataCenter
SearchContentManagement
SearchHRSoftware
Close