Problem:

Why do I get the error "PLS-00905: object SYS.VALIDATESTRUCTURE is invalid" when running the starteam_oracle_database_analyze.sql script?

Resolution:

• Product Name:StarTeam
• Product Version: 2005 - 2008
• Product Component: Database
• Platform/OS Version: All

The error will occur if you create Oracle Enterprise Manager. This script creates an Oracle package but if you use the Package wizard in Enterprise Manager is does not create a separate header and body for the package. You should instead use SQL Plus Worksheet and paste the contents of the script in there. The SQL Plus dialog should look something like

Connect OraUser/OraPassword @OraSID AS SYSDBA
>

After the package is created use the following in the same worksheet:

Connect OraUser/OraPassword @OraSID AS SYSDBA
spool myvalidate.log
execute dbms_output.enable(1000000);
set serveroutput on
execute ValidateStructure.TS("TABLESPACE_NAME_HERE", TRUE);

Borland recommends you run script against your Oracle schema to ensure optimal performance in StarTeam. A list of the scripts and how often they should be run can be found in the installation guide.