Home » RDBMS Server » Server Administration » Tablespace Maxextents and Table Maxextents
Tablespace Maxextents and Table Maxextents [message #308854] Tue, 25 March 2008 13:14 Go to next message
Messages: 9
Registered: March 2008
Junior Member
Not sure if this is the right forum for this question but here goes.

Can someone explain why you would set two different maxextent variables?

If I set my maxextents to unlimited in my tablespace does this not supercede what is set at the table level?

What is the differences between tablespace maxextents and table maxextents?

Thanks for the clarification

DM Kanz
Re: Tablespace Maxextents and Table Maxextents [message #308859 is a reply to message #308854] Tue, 25 March 2008 13:23 Go to previous message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Concepts
Chapter 1 Introduction to the Oracle Database
Section Oracle Database Architecture
Subsection Overview of Logical Database Structures
Chapter 2 Data Blocks, Extents, and Segments

Database Administrator's Guide
Chapter 9 Managing Datafiles and Tempfiles


Previous Topic: Storage Options
Next Topic: How to upgrade oracle10g R1 in solaris 5.9 x86?
Goto Forum:

Current Time: Wed Aug 23 01:18:20 CDT 2017

Total time taken to generate the page: 0.09240 seconds