Initial Data Export Prerequisites

Before performing the initial data export, verify the following requirements to avoid interruptions:

Database and Privileges

Verify the following prerequisites before you begin the export process.

  • Connection: Access to the source PDB through SQL*Plus, SQL Developer, or SQLcl. Use a service name for the PDB (such as sqlplus username/password@PDB_SERVICE).

  • User Privileges: Log in with a user granted EXP_FULL_DATABASE role (such as a dedicated export user like CISADM). Additional privileges needed:

    • CREATE TABLE for temporary metadata tables.

    • READ and WRITE on the export directory (e.g., DATA_PUMP_DIR).

    • QUERY_REWRITE and SELECT_CATALOG_ROLE for metadata queries.

  • Database Version: Oracle Database 19c or higher, with Data Pump (expdp/impdp) enabled.

  • Space Allocation: At least 1.5 times the size of the largest export group in the DATA_PUMP_DIR filesystem. Monitor via V$DATAFILE and DBA_FREE_SPACE.

Required Files

  • Scripts: Download from OCI object storage:

    • EXPORT_TABLE_LIST_GENERATION.sql: Generates the table export list.

    • EXADATA_PDB_EXPORT_SCRIPT.sql: Performs the Data Pump export.

    • MANIFEST_FILE_GENERATION.sql: Creates JSON manifests.

  • Configuration Files: Priority CSV files from ArtifactHub (uploaded by OUDI Team). These files define export groups (such as Priority 100: Critical tables; Priority 10: Auxiliary data). Customize as needed and notify DevOps for pipeline synchronization.

    • priority_config_ccs.csv (for CCS/C2M sources)

    • priority_config_wacs.csv (for WACS/WAM sources)

    • priority_config_dacs.csv (for DACS/DAM sources)