Having problems with your account or logging in?
A lot of changes are happening in the community right now. Some may affect you. READ MORE HERE

Moving the Enterprise View Oracle schema to another server

Moving the Enterprise View Oracle schema to another server

This article explains how to move the Enterprise View Oracle schema to another server.

Problem:

How to move the Enterprise View Oracle schema to another server?

Resolution:


  1. Stop the Daemons and the Agent running on the schema and disconnect all users
  2. Make a full backup of the current Oracle schema used by the Enterprise View installation (e.g. using the Oracle "exp" utility)
  3. Use the DB Install tool which comes with Enterprise View to create an empty schema on the new Oracle server. The schema must be with the same name as the one on the old server.
    Note: To create an empty schema you need to check the specific option in the DB Install wizard.
  4. Import/restore the information to the new schema from the backup of the old schema (e.g. using the Oracle "imp" utility)
  5. After you finish the import, change the schema connection options accordingly, and then submit Summary Update job so that Enterprise View can refresh the data snapshots it uses.
Note: We do not recommend that you discard the old schema before you finish the migration and make sure that the new schema is working properly.

Old KB# 14434

DISCLAIMER:

Some content on Community Tips & Information pages is not officially supported by Micro Focus. Please refer to our Terms of Use for more detail.
Version history
Revision #:
1 of 1
Last update:
‎2013-02-15 18:13
Updated by:
 
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.