How to move datawarehouse database?
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.
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
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
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
Is there a documentation about this?
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