Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Managing Storage Structures

Some of the storage parameters and all block utilization parameters can be altered with the ALTER TABLE command. The command won't fail on locally managed tablespace tables, but the effects will be irrelevant. The storage parameters that they are responsible for maintaining are maintained by the bitmaps in the segments and not in the parameters stored in the data dictionary.

The following code shows a generic example of how a table's storage parameters would be changed using an ALTER TABLE command:

					ALTER TABLE tablename
					{[storage clause and block utilization clauses]};
				

Different effects occur depending on the parameters that you alter. The most common of these follow:

• NEXT is the value for the next new extent. Subsequent ...