How to export an eHealth user database table

Document ID : KB000020809
Last Modified Date : 14/02/2018
Show Technical Document Details

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