Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Oracle Database Editor › Define General Options for an Oracle Database

Define General Options for an Oracle Database

Use the General tab in the Oracle Database Editor to add and specify the parameters for a database when you are working in an Oracle physical model.

Note: For more information targeted to your Oracle database environment, refer to your Oracle SQL reference documentation specific to your Oracle version.

To define general options for an Oracle database

1. Click Target - Oracle, Database on the Model menu.

   The Oracle Database Editor opens.

2. Select the database in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new database. Use the Enter filter text box to filter a very large list of databases to quickly locate the one that you want to define.

   Name

   Specifies the name of the database. Change the name of the database in this field.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the General tab and work with the following options:

   CONTROLFILE REUSE

   Specifes whether to reuse an existing control file when you create the database. The CONTROLFILE REUSE clause in the CREATE DATABASE statement is used if the control file with the specified name already exists when you create the Oracle database.

   MAXDATAFILES

   Lets you specify a numeric value for this parameter, which affects the control file size.

   MAXINSTANCES

   Lets you specify a numeric value for this parameter, which affects the control file size.

   CHARACTER SET

   Lets you specify the character set the database uses to store data.

   Note: The supported character sets and default value of this parameter vary depending on your Oracle version.

   NATIONAL CHARACTER SET

   Lets you specify the national character set used to store data in columns that are defined as NCHAR, NCLOB, or NVARCHAR2.

   Valid values:

   AL16UTF16

   UTF8

   Default:

   AL16UTF16

   Time Zone

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

   Default Tablespace File Type

   Select this check box to specify a file type option.

   Note: The control file size changes between some releases of Oracle, as well as when the number of files specified in the control file changes. Remember that the parameters for MAXDATAFILES and MAXINSTANCES, among other parameters, affect control file size.

4. Click Close.

   General options are defined for the database and the Oracle Database Editor closes.

Note: The user sys identified by password clause and the user system identified by password clause is not supported for Oracle 10g/11g. 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.