Physical Modeling › Oracle Physical Property Editors › Oracle Tablespace Editor

Oracle Tablespace Editor

Use the Oracle Tablespace Editor to add or modify tablespace properties.

You can open the Oracle Tablespace Editor in one of the following ways:

• Select Tablespaces from the Database menu
• Right-click a tablespace in the Model Explorer and select Properties
• Single-click a tablespace in the Model Explorer and click the Property Editor icon

Tablespaces are supported in the following features:

• Forward Engineering
• Reverse Engineering

The Oracle Tablespace Editor dialog includes the following tabs:

General Enter general options for the tablespace such as tablespace type, extent management, segment management, logging type, status, and flashback type. The available options for this tab vary depending on the Oracle version and tablespace type.

Storage Enter the storage properties for the tablespace.

Files Enter tablespace files and modify tablespace file properties.

Dependencies Displays the dependencies for a tablespace.

Comment Add or edit comments for a tablespace.

UDP Enter user-defined property values for the selected tablespace.

The following describes all of the other options available in this dialog:

• Tablespaces

  Contains all the available tablespaces in the current model.

• New

  Opens the Create Tablespace dialog where you can specify the name for the new tablespace.

• Rename

  Opens the Rename Tablespace <Tablespace Name> dialog where you can assign a different name to the tablespace.

• Delete

  Select a tablespace from the Tablespaces list box that you want to delete, and click the Delete button.

• Generate

  Generates DDL for this object during Forward Engineering. If you do not select the check box, no DDL will be generated for this object during Forward Engineering.