5 Perform the Initial Data Export
This section describes the manual process for performing the initial export of database dump files from an Oracle Database environment. This procedure is designed for enterprise users managing data extraction in Oracle Database setups, particularly for integration with Oracle Utilities Data Intelligence systems supporting applications like Customer to Meter (C2M), Water Advanced Metering Infrastructure (AMI), or Distribution Automation Management (DAM). The export leverages Oracle Data Pump to generate prioritized dump files (.dmp), associated log files (.log), and JSON manifest files (.json) that catalog the exported content.
To improve export performance and reduce the effect on production systems, the export process organizes tables into priority groups. Each group represents a logical chunk of tables (for example, core schema objects first), allowing administrators to export critical data incrementally. Each priority group is exported separately and uploaded to Oracle Cloud Infrastructure (OCI) object storage together with the associated log files and manifest files.
This manual method ensures idempotency where applicable—such as checking for existing objects before creation—and includes robust error handling to maintain data integrity. It is suitable for one-time initial loads or migrations but can be adapted for recurring backups with automation tools.
In this section: