# datamove-schema scripts

A set of scripts to datapump a schema from a local database to an ADW cloud database.

*Only tested with Oracle XE 18 (18.4.0.0.0) (local) and Oracle Database 19c (19.5.0.0.0) (ADW)* 

## Typical Usage:
* edit dms-setup.sql to supply required information
* SQL> cd \<datamove-schema\>
* SQL> @@datamove

## The scripts
* @@datamove  - Controller script that runs the following in sequence
* @@setup     - Define required variables for the run
* @@precheck  - Perform preflight checks (TODO)
* @@dpexp     - Perform data pump export on local database
* @@dpxfer    - Transfer data pump files to object storage
* @@dpimp     - Import data pump from object storage to autonomous cloud db
* @@postcheck - Perform post run checks
* @@teardown  - Undefine used

## License
This project is licensed under the terms of the MIT license.

# datamove-schema scripts

A set of scripts to datapump a schema from a local database to an ADW cloud database.

*Tested on Oracle 18c and Oracle Autonomous Data Warehouse* 

## Typical Usage:
* edit dms-setup.sql to supply required information
* SQL> cd \<datamove-schema\>
* SQL> @@datamove

## The scripts
* @@datamove  - Controller script that runs the following in sequence
* @@setup     - Define required variables for the run
* @@precheck  - Perform preflight checks (TODO)
* @@dpexp     - Perform data pump export on local database
* @@dpxfer    - Transfer data pump files to object storage
* @@dpimp     - Import data pump from object storage to autonomous cloud db
* @@postcheck - Perform post run checks
* @@teardown  - Undefine used

## License
This project is licensed under the terms of the MIT license.

Update test comment per @gvenzl suggestion
Update test comment per @gvenzl suggestion
