It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Guidelines | FAQ
Follow this question
Question details

×7,479
×6,115
×4,712
×42

question asked: May 19 '14, 1:35 p.m.
question was seen: 3,898 times
last updated: May 20 '14, 12:53 a.m.

Related questions

CLM upgrade with Oracle - 4.0.6

0
Sterling Ferguson-II (1.6k●13●288●273) | asked May 19 '14, 1:35 p.m.
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

1
permanent link
Donald Nong (14.5k●6●14) | answered May 20 '14, 12:53 a.m.
The correct table names in Oracle should be as follows.
  •     REPOSITORY_ITEM_STATES
  •     REPOSITORY_ITEM_CURRENTS
  •     REPOSITORY_ITEM_TYPES
  •     LINKS_AUDITABLE_LINK
I believe this is due to the fact that Oracle does not have a separate "schema" from the user as in SQL Server or DB2. Basically, whenever you see a table name <schema>.<table_name> mentioned for Jazz applications, you need to convert it to <schema>_<table_name> in Oracle.
Sterling Ferguson-II selected this answer as the correct answer

Your answer

Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.