CLM upgrade with Oracle - 4.0.6
CLM + DW - 4.0.2
WAS/Oracle/Linux
Upgrading to 4.0.6, noticed this information:
Before you start the Quality Management application upgrade, run statistics to update the database tables. Otherwise, the migration might take several hours.
The following tables must contain up-to-date database statistics:
- REPOSITORY.ITEM_STATES
- REPOSITORY.ITEM_CURRENTS
- REPOSITORY.ITEM_TYPES
- LINKS.AUDITABLE_LINK
For information about the Oracle database DBMS_STATS command, see the Oracle website.
However, looking in Oracle, we have found:
SQL> select instance_name, host_name from v$instance;
INSTANCE_NAME HOST_NAME
---------------- ----------------------------------------------------------------
RTMSPRS oracle.company.com
SQL> desc REPOSITORY.ITEM_STATES
ERROR:
ORA-04043: object REPOSITORY.ITEM_STATES does not exist
What if these tables are not located?
Accepted answer
The correct table names in Oracle should be as follows.
- REPOSITORY_ITEM_STATES
- REPOSITORY_ITEM_CURRENTS
- REPOSITORY_ITEM_TYPES
- LINKS_AUDITABLE_LINK