ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

How to export an eHealth user database table

book

Article ID: 20809

calendar_today

Updated On:

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: