Physical Modeling › Oracle Physical Property Editors › Oracle Database Editor › Oracle Database Editor - General Tab

Oracle Database Editor - General Tab

The following describes the options for the General tab in the Oracle Database Editor dialog:

Databases

Select a database from this list box for which you want to apply options.

CONTROLFILE REUSE

MAXDATAFILES

The value for this option must be numeric because MAXDATAFILES is an integer.

MAXINSTANCES

The value for this option must be numeric because MAXDATAFILES is an integer.

CHARACTER SET

NATIONAL CHARACTER SET

This option is for Oracle 9i and 10g only. It allows only two values: AL16UTF16 and UTF8.

Set Time Zone

This option is for Oracle 10g only. Select this check box to set your time zone. Set Time Zone includes these options:

By UTC

Select the + or – option, and select hours (HH) or minutes (MM). The valid range for UTC format is – 12:00 to + 14:00.

By Region

Time Zone

This option is for Oracle 9i only. Enter a valid range in UTC format in the text box.

Default Tablespace File Type

This option is for Oracle 10g only.

Note: The user sys identified by password clause and the user system identified by password clause is not supported for Oracle 9i or 10g. If you want to generate this clause, you can either modify the template file and add the clause, or you can use the UDP tab in this editor to supply the password value.