If you use a backing store in version 3.0.0 or earlier, perform the following procedure after installing the current version.New BusinessEvents metadata tables were added to the backing store schema in 3.0.1. If you use a backing store in version 3.0.0 or earlier, you must run the create_tables.sql script provided in the current release. It adds the new tables to the schema. Running this script does not affect any existing tables (therefore there is no need to run be-oradeploy.exe). However it’s always a good idea to back up your data before performing any schema changes.
2. Login to the Oracle server as be_user, password be_user (or whatever username and password you are using, as set in the initialize_database.sql script).
3. Navigate to the location of the scripts (by default in BE_HOME/bin) and open an SQLPlus prompt. Identify yourself as the user you logged in as.
Copyright © TIBCO Software Inc. All Rights Reserved.