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
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.
- Change (cd) to the directory where you copied the scripts.
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
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
- Change (cd) to the directory where you copied the scripts.
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: