How to move datawarehouse database?

Georg Kellner (821●3●74●95) | 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

permanent link

Francesco Chiossi (5.7k●1●7●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

It's all about the answers!

Related questions

How to move datawarehouse database?

One answer

Your answer