Tablespaces Property Sheet

When the Source Model is mapped to the Oracle Model, a tablespace is created for every database that was captured from the source database. For example, if you capture the PUBS database, a tablespace called PUBS is created in the Oracle Model. This tablespace has one datafile called PUBS.DBF that is the same size as the PUBS database in the source database.

You can create additional tablespaces in the Oracle Model by selecting the tablespaces container in the tree and clicking the right mouse button. A menu pops up that contains one item called Add. By selecting this item, a dialog appears that allows you to enter details about the tablespace you are creating.

Note: The tablespace is created in the destination Oracle database only after you run the Migration wizard.

You can remove a tablespace by selecting it in the tree and clicking the right mouse button. Select the Remove menu item, then confirm that you wish to remove that tablespace.

The tablespaces defined in the Oracle Model can be used as creation options for users, indexes, and tables.

The Tablespaces property sheet contains one page as follows:

Note: Tablespaces are not applicable if you are mapping the source model to Oracle8i Lite.