Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

[closed] RTC table names in Oracle database

I need to know what are the names of the tables created by the repotools (or the web setup wizard) for the JTS and CCM applications.
The db vendor is Oracle, and I need the names because I must create synonyms for them.

0 votes


The question has been closed for the following reason: "Problem is not reproducible or outdated" by lumar Jul 15 '18, 8:48 a.m.


One answer

Permanent link
I am not sure, why you need that information, but I would suggest to connect to the database and create a list of the database tables. Different DB vendors provide their own tools to do that. In DB2 you can do that for instance with the administrative tools.

By the way, in general direct access and manipulation of these tables and their content is not recommended. The application is supposed to handle the data.

0 votes

Comments

Ralph,
I need these pieces of information because this is a non-standard db configuration.
The tables have been created by a db user with DBA grants, but now the customer wants RTC to use a different user, without DBA grants, to access tables with read/write grants.
So, we should create tables "synonyms" for this user.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details

Question asked: Oct 19 '11, 4:44 a.m.

Question was seen: 4,694 times

Last updated: Jul 15 '18, 8:48 a.m.

Confirmation Cancel Confirm