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.
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,
Mohamed ElBeltagy selected this answer as the correct answer
Comments Hi Kenji,
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.
|
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.