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