It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,787
×267
×14

question asked: Oct 14 '13, 2:32 p.m.
question was seen: 3,974 times
last updated: Oct 16 '13, 3:12 p.m.

Related questions

FAQ - How this Forum works

Is it possible to specify custom tablespace names for Data Warehouse upgrade?

0
Jason Fregien (58●9●10) | asked Oct 14 '13, 2:32 p.m.
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

1
permanent link
Kot T. (1.5k●1●12●19) | answered Oct 16 '13, 2:59 p.m.
JAZZ DEVELOPER
edited Oct 16 '13, 3:02 p.m.

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)

See http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/r_repotools_gen_dw_upgradescripts.html&scope=null for upgrade

and...

http://pic.dhe.ibm.com/infocenter/clmhelp/v4r0m4/index.jsp?re=1&topic=/com.ibm.jazz.install.doc/topics/r_repotools_gen_dw_ddlScripts.html&scope=null for DW creation

Jason Fregien selected this answer as the correct answer
Comments
Jason Fregien commented Oct 16 '13, 3:12 p.m.

Perfect.  Thanks for the info! 

One other answer

Most liked answers ↑|Newest answers|Oldest answers

0
permanent link
Krzysztof Kaźmierczyk (7.4k●3●74●103) | answered Oct 15 '13, 3:02 a.m.
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

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.