<< Click to Display Table of Contents >>

Moving to another tablespace

Top Previous Next

The dialog lets you move a table to another tablespace. This feature is available beginning with Oracle 8i. You can also change the storage parameters.

The left side of the page shows the owner, table name, and current tablespace.

You can choose which tablespace to move the table to from a combo box.

You can enter the following storage parameters for the moved table:

Percent Free and Percent Used

Initial Number of Transactions and Maximum Number of Transactions

Initial Extent Size and Next Extent Size

Percent Increase

Minimum Number of Extents

Maximum Number of Extents

The right side of the page lists all current indexes, and gives you the option of rebuilding each index within its current tablespace.