Products Downloads


French version


 

This section contains the specific database parameters for the Oracle DBMS: directory, SID, internal password, backup directory, etc.


If using the section in the Java version of the database management tool, only the "General settings" section below applies.


This section is not mandatory.


[Oracle]

database_directory = C:\Oracle\orodata

database_sid = ORACLE2

database_password = hardis


Parameter

Type

Mandat.

Default

Description

General settings

UserUtil

string

no


Used to impose a default connection profile if the profile is not specified in the tool's settings.

PasswordUtil

string

no


Used to impose the default user profile password.

GrantedErrors

string

no


List of SQL error codes (in an absolute value, i.e. unsigned), separated by commas.

The listed error codes are ignored when interpreting a SQL script and do not stop processing.

GrantedSQLStates string no

List of SQLSTATE error codes, separated by commas.

The listed error codes are ignored when interpreting a SQL script and do not stop processing.

This parameter acts as a complement to the "GrantedErrors" parameter for DBMSs that do not return SQLCODE codes.


Creation

database_sid

string

no

calculated

SID or service name of the database (depends on the Oracle version used).

database_directory

string

no


Directory for the database files.

database_password

string

no

'oracle'

Database password.

backup_directory

string

no


Directory for backup files.

database_init_file

string

no


Database initialization file.

CfgScript

string

no


Name of the database configuration script.

This script is executed after the base is created, but before the files (PDM) are created.

This script can contain SQL commands and escape sequences.

A typical application might be a user creation script for Oracle or SQL Server bases.


Backup

database_password

string

no


Database password.

backup_directory

string

no


Directory for backup files.

database_init_file

string

no

specified*

Database initialization file.

force_shutdown

bool

no

0

Forces shutdown of the database.


Restoration

database_sid

string

no

calculated

SID or service name of the database (depends on the Oracle version used).

database_directory

string

no


Directory for the database files.

database_password

string

no


Database password.

backup_directory

string

no


Directory for backup files.

database_init_file

string

no

specified *

Database initialization file.

force_shutdown

bool

no

0

Forces shutdown of the database.

force_overwrite

bool

no

0

Overwrites an existing database without confirmation.


Deletion

database_password

string

no


Database password.

database_init_file

string

no

specified *

Database initialization file.

* If the base was created using the Database management tool

Sections [Oracle7] and [Oracle8] are taken into account for script forwards compatibility:

The [Oracle8] section is taken into account by the "Oracle" driver (Oracle 8 and later); section [Oracle7] by the Oracle7 driver.


Note: The Oracle7 driver is not any more the default activated driver. It has to be referenced manually in the APICONF.INI file in order for scripts created for Oracle7 to operate correctly.



↑ Top of page

  • Aucune étiquette