After you have created and configured the primary site in SmartPlant Foundation Server Manager, you must update each stored procedure so that they match the correct index, name, and data table spaces.
If you are upgrading SmartPlant Foundation, the stored procedures may have changed and require a manual update. Always refer to the release notes or read me file for any changes.
The installed stored procedure files are located at:
[drive]:\ Program Files (x86)\[Product Folder]\SPFServerManager\DatabaseScripts\Stored Procedures\[DB Type].
Example (staging system):
create or replace PROCEDURE VCI
varDataUserName VARCHAR2(30) := 'VTL_DATA';
varIndexTableSpace VARCHAR2(30) := 'VTL_IDX';
create or replace PROCEDURE VCT
varDataTableSpace VARCHAR2(30) := 'VTL_DATA';
Example (target system):
create or replace PROCEDURE ICI
varDataUserName VARCHAR2(30) := 'VTL_DATA';
varIndexTableSpace VARCHAR2(30) := 'VTL_IDX';
create or replace PROCEDURE ICT
varDataTableSpace VARCHAR2(30) := 'VTL_DATA';
create or replace PROCEDURE TCI
varDataUserName VARCHAR2(30) := 'VTL_DATA';
varIndexTableSpace VARCHAR2(30) := 'VTL_IDX';
create or replace PROCEDURE TCT
varDataTableSpace VARCHAR2(30) := 'VTL_DATA';
create or replace PROCEDURE TCFI
varDataUserName VARCHAR2(30) := 'VTL_DATA';
varIndexTableSpace VARCHAR2(30) := 'VTL_IDX';
create or replace PROCEDURE TCFT
varDataTableSpace VARCHAR2(30) := 'VTL_DATA';