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

Oracle Database Editor - Logging Tab

The following describes the options for the Logging Tab in the Oracle Database Editor dialog:

• Redo Log Groups

  A list box that contains the log file group names. Log file group names must be unique and must be integers. The log file group name is not mandatory, however, and can have a system-generated number instead.

• New

  Select the New button to add a new log group ID.

• Rename

  Select the Rename button to rename a Redo Log Group.

• Delete

  Select a Redo Log Group from the list box and click Delete to delete that Redo Log Group.

• FILE SIZE
• REUSE
• Redo Log Members

  A list box that contains the FileName for the log members. Each log file group can have multiple FileNames, but all FileNames must have the same file size and REUSE characteristics. For Oracle 9i and 10g, FileName does not have to be specified, since the default can be in the initialization file.

• MAXLOGFILES

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

• MAXLOGMEMBERS

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

• MAXLOGHISTORY

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

• Archive Log

  The Archive Log option includes these options:

  • NOARCHIVELOG
  • ARCHIVELOG
• FORCE LOGGING

  This option is for Oracle 9i and 10g only.

Note: For more information on these parameters, see your vendor's SQL documentation.