6.8 Deleting database tables
When changing the settings of an application that uses the database session failover functionality, deleting database tables might be required. This section describes deleting database tables.
The following table describes tables to be deleted and reference locations for the procedure of deleting.
|
Table name |
Physical name in a database |
Reference location for the procedure of deleting |
|---|---|---|
|
Application information table |
SFO_APPLICATION_ID_APP_INFO |
|
|
Session information storage table |
SFO_APPLICATION_ID_SESSIONS |
|
|
Blank record information table |
SFO_APPLICATION_ID_REC_INFO |
Template files for deleting database tables that are used in the database session failover functionality, are stored in the following location:
- In Windows:
-
Application-Server-installation-directory\CC\sfo\sql\
- In UNIX:
-
/opt/Cosminexus/CC/sfo/sql/
There are two types of template files for table deletion for each database used. The following table describes mapping of databases to be used, files, and types of tables to be deleted.
|
Database to be used |
Template file |
Types of table to be deleted |
||
|---|---|---|---|---|
|
Application information table |
Session information storage table |
Blank record information table |
||
|
HiRDB |
hirdb_delete_apptbl.sql |
Y |
-- |
-- |
|
hirdb_delete_sessiontbl.sql |
-- |
Y |
Y |
|
|
Oracle |
oracle_delete_apptbl.sql |
Y |
-- |
-- |
|
oracle_delete_sessiontbl.sql |
-- |
Y |
Y |
|
Legend:
Y: Can be deleted
--: Cannot be deleted
The following subsection describes details on template files for each database used.