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.