5.3 Regenerate the AI Helper SQL Files with the TSAM Plus Database User

Run this as the TSAM Plus schema owner (not the AI user).

$TSAM_DIR/deploy/TSAMDBSchemaUpdateConfig.sh <dbUser>

  • In `CLOUD` mode it uses the built-in documentation source.
  • In `LOCAL` mode it generates the fixed `TSAM_USERDOC_DIR:`, `TSAM_CONSOLEDOC_DIR:`, and `TSAM_FOLLOWUPDOC_DIR:` locations. The corresponding Oracle `DIRECTORY` objects must exist in the database. Missing or empty worker LLM values inherit from `AI_MAIN_` only for same-provider workers; mixed-provider workers must set their provider-specific model or Azure deployment values explicitly.

Table 5-1 Parameter List

Name Description
<db_user> The name of the TSAM Plus database user, not the name of the TSAM Plus database AI user
./TSAMDBSchemaUpdateConfig.sh [--validate-only] <db_user> The script accepts --validate-only only before the database user.

To generate the AI helper SQL files for the TSAM Plus database user tsamuser, run the command:

$TSAM_DIR/deploy/TSAMDBSchemaUpdateConfig.sh tsamuser

To change an AI provider, model, region, Azure deployment, or maximum token value independently of a knowledge-base refresh, see Update AI Providers and Models.