Overwrite
Specifies that the existing database should be overwritten with a new one when a connection is attempted.
If the Overwrite
attribute is set and there is an existing database with the same database path name as the new database, TimesTen destroys the existing database and creates a new empty database if the existing database is not in use. If the Overwrite
attribute is set and there is not a database with the specified database path name, TimesTen only creates a new database if the AutoCreate
attribute is also set (see AutoCreate). TimesTen ignores the Overwrite
attribute if AutoCreate
is set to 0. Applications should use caution when specifying the Overwrite
=1 attribute.
Required Privilege
Only the instance administrator can change the value of this attribute. If a user other than an instance administrator attempts to connect to a database with Overwrite
=1, TimesTen returns an error.
Usage in TimesTen Scaleout and TimesTen Classic
This attribute is supported in TimesTen Classic but not supported in TimesTen Scaleout.Setting
Set Overwrite
as follows:
Where to set the attribute | How the attribute is represented | Setting |
---|---|---|
C or Java programs or UNIX and Linux systems |
|
|
Windows ODBC Data Source Administrator |
N/A |