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

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

book

Article ID: 55097

calendar_today

Updated On:

Products

CA Harvest Software Change Manager - OpenMake Meister

Issue/Introduction

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.

Environment

Release: CCCHAR01300-7.1-Harvest-Software Change Manager-Concurrent User
Component: