How to change the default tablespaces (VNF_IDX, VNF_32K, VSTR_IDX, VSTR_32K) while upgrading a data warehouse on Oracle DB?
I am trying to configure data warehouse.
Current environment is:
- IBM WAS 7
-
Oracle DB 11g (non-Windows)
-
RTC 4.0.6
- No data warehouse configured
We have data warehouse tables (not sure created by which version and upgraded till which version).
I modified the teamserver.properties files with correct database connection.
Going to jts/admin wizard - Data Warehouse page - it gives me a message that I should migrate first.
Running
repotools-jts -upgradeWarehousegave me the following error in logs:
ORA-00959: tablespace 'VNF_32K' does not existI know that, for some reason, our DBA team have combined all RTC tablespaces into one.
My question is:
How can I override default value used in upgrade scripts of default values to a custom value?
We can drop data warehouse tables and re-create them using -createWarehouse if it has such an option.
Accepted answer
Hi Mohamed,
It is not supported to combine all RTC tablespaces (including for DW) into one. It is calling for disaster.
The tablespace name for RIDW schema is fixed as below.
https://www.ibm.com/support/knowledgecenter/en/SSRL5J_1.0.1/com.ibm.rational.raer.integration.doc/topics/t_install_dw_existing_db_prereq.html
(This is for Rational Insight, but RTC and Insight has the same RIDW schema structure)
If you did not follow this, then you will see many problems such as -upgradeWarehouse. Even if you manage to overcome this problem, you will see another problem sooner or later. I would recommend to create a new database DW with separated tablespaces from RTC, and fixed tablespace names.
Comments
Hi Kenji,
Thank you for your answer but I still don't understand why this is considered calling for disaster?
After all, all data warehouse tables are in the same namespace already. What difference does it make having rtc tables with them?
* we are only using RTC.
Although I cannot find the statement anymore, but I remember there is a warning that advises to set the table/tablespace/bufferpool names as explained in Knowledge center. Otherwise you will encounter the problem like you are seeing now.
There is one more critical problem to combine RTC/DW database together. You will see performance problems because the usage for DW is sometimes high and affect RTC side, or vise versa. It is impossible to set separate database parameters, which is very important. You will need to compromise at some stage, and there is nothing IBM team can help. Again, there is no reason to combine them together.