How to export an eHealth user database table

Products

• CA eHealth

Issue/Introduction

Description:

This document gives a simple explanation of how to export one or more tables from an Oracle database.

Solution:

Below is an example command you can use for exporting nh_element table. You can replace it with your table name.

 exp $NH_USER/$NH_USER tables=nh_element file=$NH_HOME/tmp/nh_element.DMP statistics=none full=yes  

To export multiple tables, separate them with commas.

 exp $NH_USER/$NH_USER tables=nh_element,nh_machine file=$NH_HOME/tmp/nh_element.DMP statistics=none full=yes 

Environment

Release: LHDEVC99000-6.3-eHealth-Live Health Upgrade Elements
Component: