It's all about the answers!

Ask a question
QuestionsTagsUsersBadges
Follow this question
Question details

×42,786
×10,908
×4,692

question asked: Oct 14 '15, 6:54 a.m.
question was seen: 2,743 times
last updated: Oct 15 '15, 11:22 a.m.

Related questions

FAQ - How this Forum works

How to move datawarehouse database?

0
Georg Kellner (840●3●78●109) | asked Oct 14 '15, 6:54 a.m.
Hello,

is there a complete description,how to move a datawarehouse-database from one server to an other?
We had the following scenario:
datawarehouse full functioning with oracle database on an old server
export/import datawarehouse-user to a new oracle server
datawarehouse wasn't available
export/import CONFIG user from old to new server
datawarehouse from jts/admin available, but not functioning
export/import several other users from old to new server
everything was fine.

I couldn't find any suitable description, how to move a datawarehouse based on oracle.
Documentation bug or will this be solved with the DCC?

greetings georg.

One answer

Most liked answers|Newest answers ↑|Oldest answers

1
permanent link
Francesco Chiossi (5.7k●1●11●19) | answered Oct 14 '15, 7:03 a.m.
edited Oct 14 '15, 7:06 a.m.
Hello Georg,

a data warehouse on Oracle is composed by several users/schemas so moving the data warehouse user and CONFIG only is not enough.

Here the complete list:
RIODS
RIDW
CONFIG
RIASSET
RISCHK
RICALM

Best Regards,

Francesco Chiossi
Comments
Georg Kellner commented Oct 15 '15, 11:06 a.m.

Is there a documentation about this?

Francesco Chiossi commented Oct 15 '15, 11:22 a.m.

Hello Georg,

I don't think I've seen any document specific to moving the data warehouse, as this is mostly a database administration topic, since there is no built in command like repotools that can be involved.

For the general structure of the data warehouse on Oracle, I find this article particularly helpful:

More Control over the Oracle Data Warehouse Setup
https://jazz.net/wiki/bin/view/Main/MoreControlOverTheOracleDataWarehouseSetup

Best Regards,

Francesco Chiossi

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.