Updating extended object definitions with new file server location


The way you execute the update_extended_object_script_location script depends on your database platform.

To update file server references on Oracle

  1. In the file structure extracted from BSA<version>-<platform>.zip, copy the script from the following location (to a directory from which you can access SQL*Plus):

    Location

    Script

    BSA<version>-<platform>/files/configurations/
    db_scripts/oracle/utility/
    update_extended_object_script_location/

    update_extended_object_script_location.sql

    Important: You must add a forward slash / at the end of the script to complete the action.

  2. Change (cd) to the directory where you copied the scripts.
  3. Modify the update_extended_object_script_location.sql script file to update old_server and new_server variables before executing the script to update extended objects definitions which are stored on the file server.

To update file server references on SQL server

  1. In the file structure extracted from BSA<version>-<platform>.zip, copy the scripts from the following locations to a directory from which you can access the sqlcmd utility:

    Location

    Scripts

    BSA<version>-<platform>/files/configurations/
    db_scripts/sqlserver/utility/
    update_extended_object_script_location/

    update_extended_object_script_location.sql

  2. Change (cd) to the directory where you copied the scripts.
  3. Modify the update_extended_object_script_location.sql file to update old_server and new_server variables before executing the script to update extended object definitions which are stored on the file server.

    The [confluence_table-plus] macro is a standalone macro and it cannot be used inline. Click on this message for details.
    Replace the variables with the following values:

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*