Is there an easy way to export/import Harvest Oracle database schema?

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

Description:

Harvest schema consists of some tables, sequences, views and constraints.
So, a simple schema export should be good enough.

Solution:

You can use Oracle exp command to perform such an export.
Ex: exp dbuser/dbpass file=export.dump compress=y log=export.log

To import such exported schema you can use Oracle imp command.
Ex: imp dbuser/dbpass file=export.dump log=import.log full=y commit=y

Note: Verify export.log and import.log for any warnings/errors. Exporting and importing statistics may give some Oracle warning messages. Follow Oracle recommendations in such cases.