Is it possible to specify custom tablespace names for Data Warehouse upgrade?
When upgrading from 2.0.0.2 to 3.0.1.2, it appears like our Oracle DBA customized the Data Warehouse creation scripts to create all the tables in a custom tablespace name, and not in the default tablespaces -- VNF_IDX, VNF_32K, VSTR_IDX, VSTR_32K, RIS_TEMP.
Now I'm trying to do an upgrade to 4.0.4, and am getting an error on the upgrade warehouse step since it's trying to create a new table in the "VNF_32K" tablespace, which doesn't exist. Is there any way to specify custom tablespace names for the upgrade script to use?
|
Accepted answer
Starting 4.0.3 (https://jazz.net/downloads/jazz-foundation/releases/4.0.3?p=news), it is possible to generate DDLs for DW upgrade (and also create) and... Jason Fregien selected this answer as the correct answer
|
One other answer
Hi Jason,
There are couple of updates regarding that in version for. Look at this document https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup. Let us know if it helps for you. Comments
Jason Fregien
commented Oct 15 '13, 1:10 p.m.
Thanks for the reply, but I already know about this page. It shows how to customize some of the settings on the user, tablespace, schema, but it does not say anything about being able to override the tablespace name that new tables get created in. |
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.